how to assign inline table filed values to existing table in new filed

[MEDHA07]

Hi All,

I am having country list around 100 and need to create a new table with new filed adding to existing table.

Country  table has country filed and Inline load has 3 values with BU Code.

Bu:

load * inline [

"BU Code"

Commercial,

Personal

AAAAA ];

final out put would be like

Country:

Country,BU code

AA ,Commercail,

AA,Personal,

AA,AAAA,

BB,Commercail,

BB,Perosnal

BB,AAAA;

[QFabian · Accepted solution]

Hi @MEDHA07 , for joining table, you can use join clause 

Load

Country

FROM YourSource;

join

Bu:

load * inline [

"BU Code"

Commercial,

Personal

AAAAA ];

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes...

[MEDHA07 · Accepted solution]

I have added 

1 as key

in both tables and showing as results as expected

[QFabian]

excellent! @MEDHA07