Remove synthetic keys

[#1]

Hi,

I have historical data for many different things. Obviously each of these is headed with the year/quarter, and there isn't really a way to organize them differently so that qlik doesn't combine them. How do I stop qlik from combining historic figures from e.g. sales revenue and sales quantity from 2003.

Thanks,

Lukas

[Anonymous]

You could qualify the tables, which will put the name of the table in front of the fields.

e.g.

Qualifiy *;

TableName:

Load

Field1,

Field2

FROM .....

Unqualifiy *;

will result in fields called TableName.Field1 and TableName.Field2

[rupamjyotidas · Accepted solution]

Three Methods:

1) Alias or Rename

2) Concatenate

3) Qualify

Pick Any.

[#4]

Thank you both, I will try to work it out.

[jagan]

Hi,

You can also try

• Link Table
• Joining Tables

Regards,

Jagan.

[Serena07]

hello Jagan,

could you please explain how to remove synthetic keys using Link Table?

Regards

Serena