This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
See script below:
Table1:Load Region&’|’&Territory&’|’&District AS zLinkKey, Region, Territory, District, Sales, InvoiceFrom …;
Table2:Load Region&’|’&Territory&’|’&District AS zLinkKey, Region, Territory, District, Revenue, DealerFrom …;
Link:Load zLinkKey, Region AS zRegionKey, Territory AS zTerritoryKey, District AS zDistrictKey, ‘Table1’ AS TypeResident Table1;
Drop Fields Region,Territory, District From Table1;
Link:Load zLinkKey, Region AS zRegionKey, Territory AS zTerritoryKey, District AS zDistrictKey, ‘Table2’ AS TypeResident Table2;
Drop Fields Region,Territory, District From Table2;
View solution in original post
Please try below link
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
Please show me you script
Thanks mate for the answer!!