Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data model where a $Syn table is created on adding a new table - ActualDemand_Market .
Below is the Tabular view:
I need Cluster field from ActalDemand_Market Table.Could you help me create the data model changes and remove the $Syn table.
The other tables are already present in the data model.
Have a look at these resources:
With these, you should be able to get rid of your $Syn table.
You need to ensure that tables are associated using a single key field. If your data model needs composite key, create it by combining fields in the script like Field1 &'|' & Field2 &'|'&Field3. Use autonumber function to create integer value out of this composite long field.
Pl go through Qlik documentation to understand different ways to handle synthetic tables like you got in your model.