HASH128 or ?

[thanstad]

First I am new to qlikview and have not so far figured out how to build up the syntax in this case.

1. Outside Qlikview there will be a conversion from old to new version of the ERP system. Well this gives me a new ERP table and shall of course be just the same as the old one exept a couple of new fields. I will now use Qlikview 10 to check the new table against the new one and I have for this example made two excelsheets which contain the fields Artnum A,B,C,Artsum in the table Old and the same for Table new exept for the new fieldes. This is my code in qlikview so far and I should add a stmt. to check if they contain the same data. Wil the Hash128 do this and since Iam a beginner could you please tell me the syntax ?

LOAD ARTNUM,
A,
B,
C,
D,
E,
ARTSUM,
A&B&C as koltab1

FROM
C:\Users\eier\Documents\INPUT_ERP_NEW.xlsx
(ooxml, embedded labels, table is Ark1);
DROP field A,B,C,D,E;

OLDTABLE:

LOAD ARTNUM,
A,
B,
C,
ARTSUM,
A&B&C as koltab2

FROM
C:\Users\eier\Documents\INPUT_ERP_OLD.xlsx
(ooxml, embedded labels, table is Ark1);

DROP field A,B,C;

Regards

Tormod hanstad

[thanstad]

Solved