Skip to main content

The 'Create CSV' module allows you to specify which columns will appear in the CSV file by selecting them in the 'Aggregated fields'

 

I would like to know how we can rearrange the columns of the Create CSV module (e.g. 'Document type' is always the first column output in the file, would like to move this to the 5th column)

 

The Create CSV file also will show commas ( , ) instead of decimal places when showing a calculated field (e.g. Throughput Time column in the Create CSV file shows 35,29 days instead of 35.29 days - I cannot see a way to alter this)

Hello Vincent,

 

when in edit mode and in the respective CSV module, there are three vertical dots right at the top in the section 'Data Structure' next to the option 'Create CSV Structure'. Clicking on these three dots will give the options 'Edit' and 'Clone'. Clicking on 'Edit' opens the CSV structure in an editable format.

 

There it is also possible to change the order of the columns.Regarding the display of the decimal separator, it is possible to apply the 'formatNumber' function within the Create CSV file on each respective column. That function allows to determine the decimal separator (as well as the thousands separator).

 

Best,

Bernardo


Reply