Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is it from an Excel spreadsheet? That can create problems in other technologies I've seen. In any case, try using the Text() function
Something like this:
LOAD
Text(somefield) AS somefield,
Text(nextfield) AS nextfield
FROM ...
May be load as Text?
Text(FieldName) as FieldName
Is it from an Excel spreadsheet? That can create problems in other technologies I've seen. In any case, try using the Text() function
Something like this:
LOAD
Text(somefield) AS somefield,
Text(nextfield) AS nextfield
FROM ...
Hi Justin,
Thanks for reply.. Its working fine
Thanks
Siva
What was not right about my response siva.boggarapu
Forget it