No idea. Works for me... after fixing the table references in the resident loads.
comm158732.qvw 163.0 K
Gysbert, thanks for replying, if pivoting from NewJoin table instead of inventory columns(FGQty, FGIQty etc.) are null
I am trying to understand,
1)When third load is from 'Inventory table' :-
that after the left join, Inventory table shows data for Data type 'Sample' appended to it(i believe data from first and second load is concatenated as there is no Noconcatenate used) then why after third load from 'Inventory' table it doesn't show values for columns specifically(Best Case Qty, Pipeline Qty, CommitQty) from second load table.
If you see Inventory table in table box you can see the appended data.
2)When third load is from 'New Join' table:-
why inventory specific columns(FGQty, FGIQty etc.) are null.
I used exists instead join, as I do not want intermediate join table. In my scenario every query data set is concatenated into one table.
From the second query I only wanted records that matched the keys of fist query. Thats why was trying left join with query1
Load product, col1, col2;
where exists(product, product);
select product, col1, col3 etc query2;
and so on..........