table merging

[souadouert]

I have a need to multiply a table a by the possible values ​​of a table b, someone help me

[sunny_talwar · Accepted solution]

May be this

Table:

LOAD Col1,

     Col2

FROM TableA;

Join (Table)

LOAD Col3

FROM Table B;

[Anil_Babu_Samineni]

Join Wil work, Initially. If you want to show blank to them which not there you should use Concantenate?

[souadouert]

thank you sunny