Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
Is there any way to find value of synthetic for particular records.
Thanks & Regards,
Kiran Kokade
Hi Kiran,
I hope u are asking values/Measures/Data for Synthetic keys/Fields .For this purpose you can go to
Table View->Right click on Synthetic table see the preview data for Synthetic keys.
Synthetic table only shows the data for synthetic columns.
you can create Listbox on sheet.
or create tablebox, and add all synthetic fields .....
That is my concern. I want to see value of synthetic key.
From where you can get synthetic key fields
It is not there is list of columns.
Is there any special setting need to see this synthetic key fields?
there is no special settings,
Month and Region are Synthetic Keys
Table Box :
Hope it helps
I want to see values what $ Syn 1 hold.
Is there any way to see that
try
= id &''& product in List Box,
it will show you what $ Syn 1 hold.
As IsrarKhan wrote, it is the combination of the fields "Month" and "Region". If you want to see what the synthetic key represents, the use a listbox and select "<Expression>". Insert into the expression "=Month&Region". Thats your synthetic key.
Hope, that helps.
Thanks for reply Imran.
So basically you are saying $ Syn 1 is holding concatenated string value.
then why we remove synthetic key and concatenate it to avoid synthetic key.
if both are doing same thing.
Thanks & Regards,
Kiran Kokade