topic Link Table Script in QlikView

Link Table Script

polisetti — Wed, 04 Jun 2014 10:31:14 GMT

Hi,

I had 4 different tables in which 4 fields are common in all the tables .So now i joined all the 4 tables and a synthetic table is formed due to that common fields.So How to create a link table for that 4 fields. Can any one please suggest me by using steps to create link table.

Re: Link Table Script

Gysbert_Wassenaar — Wed, 04 Jun 2014 10:49:09 GMT

See this discussion: Re: How do I get rid of $Syn table..how to create a link table..Please help

Re: Link Table Script

its_anandrjs — Wed, 04 Jun 2014 10:56:16 GMT

See the small example for the Link table creation by below script here are two tables one is Sales, Budget by the use of this tables create the link table

Sales:

LOAD Year&'_'&Month&'_'&[Customer Number] as Key,[Sale Amt],Year,Month;

LOAD * INLINE [

Year, Month, Customer Number,Sale Amt

2013, 4,A,15874

2014, 5,B,12569];

Budget:

LOAD Year&'_'&Month&'_'&[Customer Number] as Key,[Budget Amt],Year,Month;

LOAD * INLINE [

Year, Month, Customer Number,Budget Amt

2013, 4,A,45000

2014, 5,B,46000];

LinkTable:

LOAD Key,Year as YEAR,Month as MONTH Resident Sales;

Concatenate

LOAD Key,Year AS YEAR,Month AS MONTH Resident Budget;

DROP Fields Year,Month;