Syntax on Joining Loads with a Differences

markf1995 — Fri, 26 Jul 2013 12:38:02 GMT

Please help trying to join up tables from two DW tables to a diff table. I am trying to learn the QV syntax and I obviously dont have it.

Thanks in advance.

OLEDB CONNECT TO XXXX;

Table:

LOAD "Dimension 1",

"Dimension2",

"Dimension 3",

'DW1’ AS SOURCE,

"Dimension 1" & "Dimension 2"&"Dimension 3" as KEYQ,

SQL SELECT * from DW1Table;

OLEDB CONNECT TO XXXX;

Concatenate

LOAD "Dimension 1",

"Dimension2",

"Dimension 3",

'DW2’ AS SOURCE,

"Dimension 1" & "Dimension 2"&"Dimension 3" as KEYQ,

SQL SELECT * from DW2Table;

Concatenate LOAD

KEYQ

,if(count(KEYQ)<2,1) as "One Table"

,if(max("Dimension1")<>min("Dimension1"),1)as " Dimension1DIFF"

,if(max("Dimension2")<>min("Dimension2"),1)as " Dimension2DIFF"

,if(max("Dimension3")<>min("Dimension3"),1)as " Dimension3DIFF"

Resident Table

Group by KEYQ;

topic Syntax on Joining Loads with a Differences in QlikView