Combining tables with chosen columns

[jacek2703]

Hi there,

I have two tables: the first one contains many columns, the 2nd one the necessary columns only. I need to load only chosen columns from the first one and then combine the table with the 2nd one.

What is wrong with the code below? After loading data no error messages but nothing happens - no table loaded.

sub QVDload
LOAD
"%Product ID",
"Product ID",
%Date,
"%Customer ID",
"Customer ID",
"# Sales Out Quantity"
FROM [lib://bms3_emea_root_folder/qvd_facts/f_WESI_SO.qvd](qvd);

Concatenate
load * from [lib://PL_CONS_TRACKER (ad_jwozniak)/EuSO.qvd](qvd);
end sub;

Thank you for any help.

[Taoufiq_Zarra · Accepted solution]

if I understood correctly @jacek2703  why use Sub ... end sub;

to concatenate the 2 table you need to have the same names in both table

like :

QVDload:
LOAD
"%Product ID",
"Product ID",
%Date,
"%Customer ID",
"Customer ID",
"# Sales Out Quantity"
FROM [lib://bms3_emea_root_folder/qvd_facts/f_WESI_SO.qvd](qvd);

Concatenate
load 

"%Product ID",
"Product ID",
%Date,
"%Customer ID",
"Customer ID",
"# Sales Out Quantity"

from [lib://PL_CONS_TRACKER (ad_jwozniak)/EuSO.qvd](qvd);

if you dont have in EuSO the same name of field use .... as ...,

[jacek2703]

Many thanks!!!

[jacek2703]

thanks again. And do you know how to solve this issue?

https://community.qlik.com/t5/New-to-Qlik-Sense/Dynamic-calculated-field-WOI/td-p/1828550

I have been struggling with it for several days and I have no idea how to handle it.