Linktable with binary

[#1]

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;

[Gysbert_Wassenaar]

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;