Compare Data between QVD and Excel

ashishpalkar — Tue, 08 Sep 2015 15:37:47 GMT

I have ID# which is primary key coming from 5 QVD's.

I have listed some ID's for highlighting purpose in excel.

I want to create a text box which will display "Yes" , if ID# of QVD matches with ID# of Excel else display "No".

thanks,

Re: Compare Data between QVD and Excel

malini_qlikview — Tue, 08 Sep 2015 17:24:39 GMT

Hi,

You can do this in several ways, listing one method,

1.Load ID's from QVD

TEMP_DATA:

Load

ID,

Column2,

Column3

Fron QVD;

Left join IDs from E to the QVD data with a flag

Left join

Load

ID,

'YES' AS Flag

From Excel;

Now create a if statement to flag 'NO' values other that 'YES'

FINAL_DATA:

LOAD,

ID,

Column2,

Column3,

If(Flag='YES',Flag,'NO') AS Flag

Resident TEMP_DATA;

Drop Table TEMP_DATA;