How can I sort the fields and store in the excel maintaining the sequence of the columns ?

userpd_2021 — Fri, 15 Nov 2024 21:52:14 GMT

Hi All,

Simplifying my question with an example/ a case. I am loading an storing the data in excel format

Excel:
Load Distinct
Region,
Location,
Customer,
Customer Email,
Area
resident table ;
Store Excel into '$(vFileNamePath)'(txt);

Desired excel output;

Region	Location	Area	Customer	Customer Email

Output that I am getting in the excel is in alphabetic format. How do I get the above output.

Area	Customer	Customer Email	Location	Location

Re: How can I sort the fields and store in the excel maintaining the sequence of the columns ?

Qrishna — Tue, 25 Apr 2023 14:59:36 GMT

Set vFileNamePath = 'C:\Users\Krrish\Desktop\Comm\excel.csv';

Excel:
Load * inline [
Region, Location, Customer, Customer Email, Area
A, xyz, pqr, pqr@abc.com, efg
];

Store Excel into '$(vFileNamePath)'(txt);

This works for me.