Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have multiple tables in data load editor with different field names and granularity. Some fields like Product, Project, & City are common across all the tables for which I am trying to you link tables concept to avoid synthetic keys and to join them with each other. However, the column names are not the same in each table eg, Product, Products, ProductName, these are the different column names but have the same data that I want to link. I tried creating aliases for them but its giving an error saying that the "product' the alias doesnt exist in the table. Can someone please suggest a way around?
Hi,
Can you share an example of the script that doesn't work, and screenshot of the error and model ?
To avoid synthetic keys, you can use functions like Hash128 (if in QVD) or Autonumber (if in app), to combine multiples fields into one key.
Regards