Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
try this?
T:
Load A as AA, * from SISO;
Inner join
Load B as AA, * from Product; Concatenate(T)
G:
Load H as AH, * from SISO;
Inner join
Load G as AH, * from Product;
Please read how Inner Join works, When you say you are getting no records could be record are not internally matched from each tables. First try with two different loads instead all together. https://www.w3schools.com/sql/sql_join_inner.asp
Thanks.
But as try your suggestion below, it didnt work. Both two tables work with inner join, just concatenate them, it didnt work. Thanks.
T: Load A as AA, * from SISO; Inner join Load B as AA, * from Product; Concatenate(T) G: Load H as AH, * from SISO; Inner join Load G as AH, * from Product;
Best Regards,
Haifeng
run this and show the output
T:
Load * Inline [
Field1
C
B];
Inner join
Load * Inline [
Field1
A
C];
Concatenate
Load * Inline [
Field2
C
B];
Inner join
Load * Inline [
Field2
A
C];