I am new to Qlik Sense, and tried loading several text files. These are an invoice file, and I had two invoice detail tables that describe the products / services that are rendered. in each of these detail tables there's an employe# key, which caused Qliksense to find a synthetic key. My thoughts were then to load both detail tables into a single detail table, adding a calculated column to distinguish between them. The two tables are similar enough in nature to be combined (qty, price, etc...).
I read that for Qlik Sense to combine two tables, all I really need to do is name the columns the same way, but when I load the second table I keep getting errors that the field names must be unique, and it tries to name each column name with a prefix of the table.
Should I be doing this manually by editing the individual load statements?
Thanks Andy, I tried to go to the data load editor, and do a copy of the load statements there. The section is locked. If I unlock it, i will not be able to re-lock it... How do you go about actually copying the load statements?
I have the same problem. I have 2 different tables that have some field names in common. Although it is on purpose, there's an alert in Qlik Sense and adds the second table with prefix on the field names. I think one problem can be the amoung of relative fields between the tables. I have 12 fields that are the same between the tables. I tried removing some of them to 4, and it works (Qlik creates the synthetic keys). But I wanted to know if there's a max number of synthetic keys (fields) allowed in Qlik? or if I can try another method to keep all the fields.