Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have one qvw with binary and I need make the linkedtable with the external data.I I understood the concept of link table, but, I not getting to apply the concept in qvw with binary, below the example.
fact that I have in my qvw
fact | |||
idcustomer | idsku | value | qty |
1 | 1 | 10 | 1 |
1 | 2 | 20 | 5 |
1 | 3 | 30 | 9 |
2 | 1 | 40 | 4 |
1 | 2 | 50 | 3 |
2 | 3 | 20 | 5 |
fact external.
fact external | |||
idcustomer | idsku | value | qty |
1 | 1 | 15 | 4 |
1 | 2 | 55 | 9 |
1 | 3 | 6 | 7 |
2 | 1 | 3 | 5 |
8 | 1 | 15 | 2 |
1 | 15 | 88 | 3 |
so the last two lines of fact external, need to be show, therefore , the concatenate with "&" does not function, i thought in link table, but when i do linktable with table fact using RESIDENT in a fact, the model fail, because generate the table like this - fact-1, fact_external -1...
bellow follow the generic script
load
idcustomer&'|'&idsku as key,
value
FROM ..\Desktop\fact_external.xlsx
(ooxml, embedded labels, table is fact_external);
fact:
load Distinct
idcustomer&'|'&idproduto as key,
value
Resident fact;
link:
load Distinct
key,
idcustomer,
idsku
Resident fact;
link:
load Distinct
key,
idcustomer,
idsku
Resident fact_external;
The tables seem to have exactly the same fields. So it's probably a better idea to concatenate them. That will happen automatically if you don't specify the Noconcatenate keyword.
load
idcustomer,
idsku,
value,
qty,
'fact_external' as source
FROM ..\Desktop\fact_external.xlsx
(ooxml, embedded labels, table is fact_external);
load Distinct
idcustomer,
idproduto as idsku,
value,
qty,
'fact' as source
Resident fact;