Syntax on Joining Loads with a Differences

[markf1995]

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;