How to create link table by getting rid of sync table

[deepak_km9886]

I have following sample and i am getting synthetic keys. I dont want to rename the fields and get rid of synthetic keys, rather i want to eliminate it by creating link table,

can anyone please help me with this by providing the script. I want the key for region,territory and district.

[dsharmaqv]

Hi

Please try below link

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

[vitaliichupryna · Accepted solution]

Hi Deepak,

See script below:

Table1:
Load
      Region&’|’&Territory&’|’&District AS zLinkKey,
      Region,
      Territory,
      District,
      Sales,
      Invoice
From …;

Table2:
Load
      Region&’|’&Territory&’|’&District AS zLinkKey,
      Region,
      Territory,
      District,
      Revenue,
      Dealer
From …;

Link:
Load
      zLinkKey,
      Region       AS zRegionKey,
      Territory     AS zTerritoryKey,
      District       AS zDistrictKey,
      ‘Table1’     AS Type
Resident Table1;

Drop Fields Region,Territory, District From Table1;

Link:
Load
      zLinkKey,
      Region      AS zRegionKey,
      Territory    AS zTerritoryKey,
      District      AS zDistrictKey,
      ‘Table2’    AS Type
Resident Table2;

Drop Fields Region,Territory, District From Table2;

[deepak_km9886]

I tried it, but the problem is tables are from SQL Server!!I'm getting error in Link table! Can u write the sample script and show it. It'll be helpful

[vitaliichupryna]

Please show me you script

[deepak_km9886]

Thanks mate for the  answer!!