Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
thanstad
New Contributor III

HASH128 or ?

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
Tags (1)
1 Reply
thanstad
New Contributor III

HASH128 or ?

Solved

Community Browser