Synthetic Keys

[Luffy20]

Hi All

I am trying to remove synthetic keys by renaming the fields  it was working,but the data is not coming properly ,can you guys help me with any other method

Thanks in regards

[Kushal_Chawda]

@Luffy20  You can create custom Key by concatenating those fields. For eg. if synthetic key contains two columns, you can create Key as below in respective table So that they will have Key and then rename the column

Column1 & '|' & Column2 as Key

rename Column1 to Column1_table1;

rename Column2 to Column2_table1;

[rwunderlich]

Here is a walkthrough on methods of removing synthetic keys

https://qlikviewcookbook.com/resolving-synthetic-keys/

-Rob