Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
SRS
If all of the data in that column is supposed to have 3 digits, you could use the formula:
=num(Data, '000')
I hope that helps!
Hi,
While loading the data use Text() function to keep the 0 as it is.
Like this.
Load Text(Field1) as Filed1 from ABC;
This will keep 001 as it is even if you export it to excel.
Regards,
Kaushik Solanki