topic Re: loading excel data into qlik sense consistent with excel in App Development

loading excel data into qlik sense consistent with excel

coco — Sun, 19 Sep 2021 04:04:00 GMT

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);

Re: loading excel data into qlik sense consistent with excel

AshutoshBhumkar — Sun, 19 Sep 2021 04:41:41 GMT

Hi, Try converting Code into Text.

like Text(Code) as Text

Re: loading excel data into qlik sense consistent with excel

Vegar — Sun, 19 Sep 2021 05:14:56 GMT

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 .

Re: loading excel data into qlik sense consistent with excel

coco — Tue, 21 Sep 2021 10:26:08 GMT

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-sense/td-p/1837875

Re: loading excel data into qlik sense consistent with excel

coco — Tue, 21 Sep 2021 10:26:42 GMT

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-sense/td-p/1837875