1 Reply Latest reply: Oct 9, 2013 9:29 AM by Gysbert Wassenaar RSS

    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;

        • Re: Linktable with binary
          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;