Skip to main content
1-Visitor
November 25, 2015
Solved

Change the location of the field in the InfoTable

  • November 25, 2015
  • 1 reply
  • 4014 views

Hi everyone,

In our case,we want to change the location of fields in the InfoTable.
We would like to  show the data like report.

For example,in this picture,we want to change the column "Hours" to the first column.

Is there any solutions?

Many thanks,
Allan,

(Lanner, b10102127@gmail.com)

Best answer by paic

can't really change the order of your columns in the infotable, but if you are outputting that to a Grid, you can go into Configure Grid columns to rearrange the column order in the grid.

Oops i see csv export. you can try editing the datashape but I don't think that will cause a change.

you could try to apply some sort ahead of returning the result and see its influence.

1 reply

1-Visitor
November 25, 2015

Hi Allan,

How would you show the data of the InfoTable ? With a Grid, the order of the columns can be changed manually.

Quang-Dung

lyi-chi1-VisitorAuthor
1-Visitor
November 25, 2015

Hi Quang-Dung,

Thank for your response.

In our case,we would like to export the data as a CSV  file.

We need to change the position of the columns in our data,and display it as a report.

For example:The report will show the "Hours" at 1st column.

Many thanks,

Allan

1-Visitor
November 25, 2015

In my case, it was possible through a Stream and not a ValueStream. The DataShape binded to the Stream determines the order of the columns in the data.

Of course, there's an extra work to populate the Stream, but a Stream give more manipulations on data. Especially it could be used with the DataFilter and then DataExport to export only the data filtered.