topic need suggestion in QlikView

need suggestion

soniasweety — Sat, 16 Nov 2024 20:33:45 GMT

Hi all,

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?

rubenmarin — Fri, 28 Jun 2019 06:26:04 GMT

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 — Fri, 28 Jun 2019 06:42:59 GMT

thanks i will try and let you know,