load script

Wed, 11 Jun 2014 09:58:05 GMT

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!

Re: load script

alexandros17 — Wed, 11 Jun 2014 10:08:52 GMT

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

topic Re: load script in QlikView

load script

Re: load script