Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have two table like below
Table A | |
Leg Details | Fruits |
leg1 | Apple |
leg2 | Mixed Fruits |
leg3 | Mango |
leg4 | Orange |
Table B | |
Leg Details | Status |
leg1 | dispatched |
leg1 | stocked |
leg2 | processed |
leg2 | dispatched |
leg2 | stocked |
leg3 | processed |
leg3 | dispatched |
leg3 | stocked |
leg4 | processed |
leg4 | dispatched |
and i need the load statement to get the below output table
Table C | ||
Leg Details | Fruits | Status |
leg1 | Apple | dispatched |
leg1 | Apple | stocked |
leg2 | Mixed Fruits | processed |
leg2 | Mixed Fruits | dispatched |
leg2 | Mixed Fruits | stocked |
leg3 | Mango | processed |
leg3 | Mango | dispatched |
leg3 | Mango | stocked |
leg4 | Orange | processed |
leg4 | Orange | dispatched |
Can someone help me with the load script
I don't think whether you need any thing changes while load. How is your script looks like.
My Script is this
TableA:
LOAD [Leg Details],
Fruits
FROM
[https://community.qlik.com/message/1276808]
(html, codepage is 1252, embedded labels, table is @1, filters(
Remove(Row, Pos(Top, 1))
));
Join (TableA)
TableB:
LOAD [Leg Details],
Status
FROM
[https://community.qlik.com/message/1276808]
(html, codepage is 1252, embedded labels, table is @2, filters(
Remove(Row, Pos(Top, 1))
));
PS - enclose attached Output and App