Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to remove synthetic keys.
renaming fields,using qualify I know..I want some other solutions
May i ask why you need other solutions than renaming fields?
What do you want to achieve with another solution?
As long as you have several fields with the same name in the tables, you will get synthetic keys.
/Martin
May i ask why you need other solutions than renaming fields?
What do you want to achieve with another solution?
As long as you have several fields with the same name in the tables, you will get synthetic keys.
/Martin
You can create a fact table containing both (or more) key fields
Then create a key of combined field using autonumberhash128(Field1,Field2) for example.
FactTable:
LOAD autonumberhash128(Field1,Field2) as %Key,
Field1,
Field2
resident MyTable;
MyTable2:
LOAD autonumberhash128(Field1,Field2) as %Key,
Field3,
Field3
resident MyTable;
drop table MyTable;
Rgds,
If we have more synthetic keys then renaming may not be easy for that any other solution or comment
Hi:
Try to concatenate 2 fields in one, that way you´ll have only 1.
Rename the 2 simple fields differently to filter later on.
If the data is large then...............