Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data correction

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

2 Replies
Nicole-Smith

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!

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!