JOINS

[Surya]

Hello,

I have table Prod that contain 200 products

Prod

a,

b,

c

now i need to add each product ab,cd

expected output is when user select in product field a

a,

ab,

cd

when user select b in prod field

b,

ab,

cd

..

[Surya · Accepted solution]

T1:
LOAD * INLINE [
Name
A
B
C
];

Join(T1)

LOAD * INLINE [
Alias_Name
ab
cd
];

Join(T1)

Load Name,Name AS Alias_Name

Resident T1;