Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
MEDHA07
Contributor III
Contributor III

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

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;

Labels (1)
2 Solutions

Accepted Solutions
QFabian
Specialist III
Specialist III

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...

 

QFabian

View solution in original post

MEDHA07
Contributor III
Contributor III
Author

I have added 

1 as key

in both tables and showing as results as expected

View solution in original post

3 Replies
QFabian
Specialist III
Specialist III

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...

 

QFabian
MEDHA07
Contributor III
Contributor III
Author

I have added 

1 as key

in both tables and showing as results as expected

QFabian
Specialist III
Specialist III

excellent! @MEDHA07 

QFabian