Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Unlink 2 certain tables

Hi,

There is a question about data load.

I have 3 tables with the ID as key, for example

A:

ID,

Field1,

Field2

B:

ID,

Field3,

Field4

Main:

ID,

Field5,

Field3

So i want to link table A and B to the Main using ID individualy and there isn't any link between A and B by ID. It mess up the data

Could anyone give me and advice?

thanks inadvance

3 Replies
Highlighted
Partner
Partner

Re: Unlink 2 certain tables

hi 

you can do like this 

A:

ID,

Field1,

Field2

B:

ID as IDb,

Field3,

Field4

Main:

ID,

ID as IDb,

Field5,

Field3

Highlighted
New Contributor III

Re: Unlink 2 certain tables

Hi,

I'm trying to avoid this way because i cant extend the data with 2 id fields

Anw, thank you

Highlighted
New Contributor III

Re: Unlink 2 certain tables

Sorry for bumping the topic.