Compare Data between QVD and Excel

[ashishpalkar]

Hi

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,

[malini_qlikview]

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;