Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QV Experts,
I created an QVD from another QVD applying where condition.
Now when i checked the QVD, i see the first column with 1 digit less than the Source QVD.
Can anyone suggest, what might went wrong.
Thanks,
Sasi
Hi Sasi,
Have you tried to pull the data from your first QVD into a sample QVW and verify the first column?
can you share the sample app or give more information.
Hi KrishaPriya,
Yeah. From the First QVD it retrieves the data correctly. Only when i store it in the second QVD applying where condition. That too, only the first column i lost one digit.
Thanks
Sasi
Hi Sasi,
Post the sample application or the data set and the output you are getting from the data set
Regards,
Srini.
Use Num function. QlikView understand that first column is number, and left zeros are removed. With num function QVD will store all digits will be stored.
Num(1,'00') = 01
Kind regards
When you load the broken QVD in an internal table and open the table viewer (Ctrl-T), is the broken column left or right-aligned?
try putting SET VERBATIM = 1;
or
use text()
Leading zeroes can fall off in qlik scripting.
Thanks Manuel & Dion.
Hi Sasi,
just do a small assignment and confirm yourself.
open that first qvd file and export that data to Excel file.and just fetch the data from newly created excel file if you find both data are match then no issue else your data have some problem.