Missing data

[siva_boggarapu]

Hi Team,

I have data like below

000021000

000031000

When I am loading data into Qlik Sense

The data appearing like

21000 and 31000 but I want data as it is like 000021000,000031000..

Thanks,

Siva

[sunny_talwar]

May be load as Text?

Text(FieldName) as FieldName

[JustinDallas · Accepted solution]

Is it from an Excel spreadsheet?  That can create problems in other technologies I've seen.  In any case, try using the Text() function

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/Interpretation...

Something like this:

LOAD

     Text(somefield) AS somefield,

     Text(nextfield) AS nextfield

FROM ...

[siva_boggarapu]

Hi Justin,

Thanks for reply.. Its working fine

Thanks

Siva

[sunny_talwar]

What was not right about my response siva.boggarapu‌

Forget it