Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Linktable with binary

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
idcustomeridskuvalueqty
11101
12205
13309
21404
12503
23205

fact external.

fact external
idcustomeridskuvalueqty
11154
12559
1367
2135
81152
115883

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;

1 Reply

Re: Linktable with binary

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;