topic Combining tables with chosen columns in Connectivity & Data Prep

Combining tables with chosen columns

jacek2703 — Fri, 13 Aug 2021 08:30:57 GMT

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.

Re: Combining tables with chosen columns

Taoufiq_Zarra — Fri, 13 Aug 2021 08:42:17 GMT

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

Re: Combining tables with chosen columns

jacek2703 — Fri, 13 Aug 2021 14:07:35 GMT

Many thanks!!!

Re: Combining tables with chosen columns

jacek2703 — Tue, 17 Aug 2021 17:19:01 GMT

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.