One to Multiple Rows Map

[Anonymous]

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

[Anil_Babu_Samineni]

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