Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

need suggestion

Hi all,

@sunny_talwar   @rubenmarin 

i want one help  below is my  senario 

i have main table with    two ID columns

and one dimension table with  one ID column  .  so want to link main table two id columns to dimension ID column

MainTable:

Sale_ID

Pro_ID

 

DImTable:

Sale_ID

Now Bussines told  sale_id and Prod_id  should link to  Sale_Id in Dim table

 

how to do this?

Labels (1)
1 Solution

Accepted Solutions
rubenmarin

Hi, It can be different options.

One can be duplicate data in main table, like:

Maintable:

LOAD *, Sale_ID as RelationField_ID From...;

Concatenate LOAD *, Pro_ID as RelationField_ID From...;

 

And dimTable should use RelationField_ID to link tables:

DimTable:

LOAD Sale_ID as RelationField_ID

...

 

View solution in original post

2 Replies
rubenmarin

Hi, It can be different options.

One can be duplicate data in main table, like:

Maintable:

LOAD *, Sale_ID as RelationField_ID From...;

Concatenate LOAD *, Pro_ID as RelationField_ID From...;

 

And dimTable should use RelationField_ID to link tables:

DimTable:

LOAD Sale_ID as RelationField_ID

...

 

soniasweety
Master
Master
Author

thanks i will try and let you know,