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;