load script

[#1]

Hi All,

I'm loading 2 table files into my qlikview file. Each of those table files are having a data field. I want to find difference of these date fields which belong to 2 different table files. Can anybody please tell me how to find difference between these date fields which belong 2 diff loaded table files

Thanks!

[alexandros17 · Accepted solution]

Suppose the first file has fld1, fld2 while the second file has fld1 and fld3

the fields fld1 link the tables togheter, (and you surely have fields like this)

so:

TMP:

noconcatenate

Load * resident TAB1;

join

Load * resident TAB2;

drop tables TAB1, TAB2;

FINAL_TAB:

noconcatenate

Load

     fld1,

     if(fld2 <> fld3, 'Diff', 'Equal') as fldStatus

Resident TMP;

drop table TMP;

let me know