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