loading excel data into qlik sense consistent with excel

[coco]

Read the CODE column from excel. The data is the text version type, starting with 000, as shown in pic1, but the data read by qlik sense automatically removes the previous 000, as shown in pic2. I hope the data read is consistent with that in Excel. What should I do?

Here is my code in qlik sense.Where should be modified?

Table:
LOAD
CODE
FROM [lib://file/file 2021.09.14.xlsx]
(ooxml, embedded labels, table is Sheet1);

[AshutoshBhumkar]

Hi, Try converting Code into Text.

like Text(Code) as Text

[Vegar]

If you expect all CODE values to be a numeric integer value with five positions, then you can format the output with NUM(CODE, '00000'). If it is a mix of numeric and string values then I would go with the solution from @AshutoshBhumkar .

[coco]

Thank you very much!😀

Could you help me another question?

https://community.qlik.com/t5/App-Development/A-record-is-different-between-sql-server-and-qlik-sens...

[coco]

Thank you very much!

Could you help me another question?

https://community.qlik.com/t5/App-Development/A-record-is-different-between-sql-server-and-qlik-sens...