Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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 .....;