Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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...