Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Newuser_qlik
Contributor II
Contributor II

Sort order for columns in CSV

Hi All,

I have the below columns. But when storing in CSV format in script, the order of columns are not correct. Can you let me know how to get the MMM-YY columns sorted and stored in CSV

ID  AMOUNT  DATE Nov-23 23-Dec 23-Jan 23-Feb 23-Mar 23-Apr 23-May
3119 41,202.04 11/24/23 13 0 12 88 56 12 16.53
6040 46,454.56 01/20/24 0 0 45 45 463 11 512.43
22125 45,470.04 01/29/24 0 0 1000 233 232 96 -49.59
22691 45,470.04 01/29/24 0 0 200 244 56 100 525.21
70039 37,400.32 02/08/24 0 0 25 25 77 22 -33.88
Labels (1)
1 Reply
maxgro
MVP
MVP

for the order of columns try store column1, column2, ..... from ... into ....

STORE
[23-Jan], [23-Feb], [23-Mar], [23-Apr], [23-May],
[Nov-23], [23-Dec] 
ID,
AMOUNT,
DATE
FROM ..... INTO .....;

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptR...