Data Changing when saving to QVD

[usamashahid]

I created a new qvd from sql database. Once the qvd is generated data is not matching with sql (e.g. I have two items '03011001' and '3011001' in sql it is showing as two separate lines but once i load the qvd '0' is added in '3011001', so only 1 item appears which is '03011001' and there is no '3011001'.

I've attached a snapshot of Qlik and SQL for reference. 

Anyone, please help me understand this.

[lorenzoconforti]

Usually the issue is that leading zeroes are dropped rather than added

Can you share the part of the script where you load the data from SQL?

[Kashyap_R]

Hi

try by converting it to text format using Text()

Hope this helps

Thanks

[usamashahid]

attached is the script where qvd is created from sql.

[usamashahid]

Already tried using Text(FieldName) but no luck

[Kashyap_R · Accepted solution]

Hi

try like this

Abc:
LOAD

Text(ID) as ID,
Name,
Fees;
SQL SELECT ID,
Name,
Fees
FROM Database.dbo.Table;

Store Abc into //loc/Abc.qvd(QVD);

Hope this helps

Thanks

[lorenzoconforti]

Just to rule it out, how are you reloading the qvd? 

[usamashahid]

I'm using the script as reload as well.