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;
