Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

How can i bring some fields of different tables/sources and create a new table in the script?

Hi QV users,

How can i bring just few fields of different tables/sources (with at least a key field) and create a new table in the script?

What's the right expression to do this?

Thanks,

Mattia

Labels (1)
2 Replies
Partner
Partner

Hi Mattia,

 

As long as we need to simplify - such operators would be different JOINs (Left Join/Right Join/Inner Join/Outer Join)

Mapping field may be another method to achieve this.

Basically, you need to know what you want to do with the data.

 

Here is an example of how you can use Left Join:

 

T1:

LOAD * INLINE [

Amount, Country, Year

100, Italy, 2019

150, UK, 2019

140, Australia, 2019

];

 

LEFT JOIN (T1)

LOAD * INLINE [

Country, Region

Italy, EU

Australia, AUS

];

 

Here are results:

AmountCountryYearRegion
100Italy2019EU
150UK2019-
140Australia2019AUS

 

Creator II
Creator II

Hi Stoyan and thanks for the message.

This question is part of a more complex project.

Please, can you help me to solve this problem? 

https://community.qlik.com/t5/QlikView-Scripting/How-can-i-Left-Join-multiple-tables/m-p/1648532#M97...

Mattia