I load data from excel file and there data in a column is like 001,002,003 but when i create straight table and send report to excel it shows 1,2,3 of this column vaues, please help me for this.
If all of the data in that column is supposed to have 3 digits, you could use the formula:
I hope that helps!
While loading the data use Text() function to keep the 0 as it is.
Load Text(Field1) as Filed1 from ABC;
This will keep 001 as it is even if you export it to excel.
Retrieving data ...