Need help on synthetic key

[agni_gold]

I have 2 Tables , having large number of columns , i am attaching the sample tables here. In both table you can see there are some columns are common , but these tables are not liked together because there is no relation . but i need to put in same data model .

But common columns creates the synthetic key . I want to sort the both amounts on the basis of brand , product , customer and year , month .

We can not create the composite key also , because i need to give filter listbox in my dashboard . please help how to link without synthetic key .

[swuehl]

Have you considered concatenating your two tables?

[agni_gold]

no these are individual tables , we can not concatenate

[swuehl]

Not sure if I understand, there is no relation between the table, you want them isolated?

Maybe consider using

QUALIFY *;

Table1:

LOAD * FROM Table1;

Table2:

LOAD * FROM Table2;

UNQUALIFY *;

[MarcoWedel]

please post some sample data and your expected result.

thanks

regards

Marco

[arsal_90]

Create Link Table for Common dimensions. Hopefully it will resolved your problem.

[agni_gold]

yes i have tried this also , but the problem is that when i want to provide the filter for Brand, Product and Customer , both the data will not be sort.

[agni_gold]

for link table i have to add all the columns because there is no primary key in both the tables.

[swuehl]

Maybe you can use a kind of trigger to copy selections in the field of interest around the two tables, to allow the user to select in one list box and filter both tables.

[agni_gold]

Can you please explain little bit more about this ?

It seems to good for my question..