Concatenate and Inner join priority

[zhaohaifeng]

Hi Friends, We faced the challenge as below, Now we want to concatenate two tables with inner join, but as below scripts, the value was null, i supposed the calculate order was wrong, it calculate calculate concatenate first then calculate the inner join, so my question was how to set inner join was high priority to calculate? Thanks. T: Select A as AA, * from SISO Inner join Select B as AA, * from Product Concatenate(T) Select H as AH, * from SISO A Inner join Select G as AH, * from Product

[Anil_Babu_Samineni]

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

[zhaohaifeng]

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

[Anil_Babu_Samineni]

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];