Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
theaokii
Contributor III
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
lironbaram
Partner - Master III
Partner - Master III

hi 

you can do like this 

A:

ID,

Field1,

Field2

B:

ID as IDb,

Field3,

Field4

Main:

ID,

ID as IDb,

Field5,

Field3

theaokii
Contributor III
Contributor III
Author

Hi,

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

Anw, thank you

theaokii
Contributor III
Contributor III
Author

Sorry for bumping the topic.