Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
Colleagues, how to connect correctly two tables with 3 the same fields?:
Source1:
LOAD WareHouse,
Nomenclature,
Date,
Volume
FROM
[Test.xlsx]
(ooxml, embedded labels, table is Source1);
Source2:
LOAD WareHouse,
Nomenclature,
Date,
Volume1
FROM
[Test.xlsx]
(ooxml, embedded labels, table is Source2);
Thanks
How do you want the output?
You can concatenate both tables, or join them.
For the first alternative, use this:
Source1:
LOAD WareHouse,
Nomenclature,
Date,
Volume
FROM
[Test.xlsx]
(ooxml, embedded labels, table is Source1);
Concatenate (Source1)
LOAD WareHouse,
Nomenclature,
Date,
Volume1
FROM
[Test.xlsx]
(ooxml, embedded labels, table is Source2);
Regards
Eduardo
I would probably concatenate them:
Just rename Volume1 to Volume
And your results will look like this:
when you say connect, are you wanting one table with the same 3 fields but the data from all 3?
if so, you will need to use Load as ,field name> to get the field names from all tables to be the same - from the data above, Volume1 as Volume.
You do not really need to include the Concatenate statement because QlikView will do an automatic concatenation when loading tables and all of the fields are the same
But, if he wants to have Volume separated from Volume1, the concatenate is needed
depending on the reuirement, that is a true statement and agree 100%. If there is a volume field and a volume1 field once the tables are concatenated/joined he could have an issue with nulls
Qlikview by default performs join but you may see synthetic table.
You can use Join or Concat to resolve the keys.
Table1:
Load
Join
Table2:
Load
Thanks,
SV
the current data model as-is will be crating those synthetic keys unless a concatenate or join is done to get both tables into one
see synthetic keys being created below