One to Multiple Rows Map

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I have two table like below

and i need the load statement to get the below output table

Can someone help me with the load script

Re: One to Multiple Rows Map

Anil_Babu_Samineni — Sun, 28 May 2017 17:45:27 GMT

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