Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Should I be using the CONCATENATE statement?
Am I going about this completely wrong?
Thanks in advance
Paul
Post your load script and error messages and I'm sure one of us can sort you out paul.
What you are trying to do seems a perfectly standard requirement for Sense to handle.
Hi, Paul
You probably has two columns in the table with the same name or you are aliasing a column to a name already in use for that table.
Pleas, let me know if this was the problem.
Eduardo
You can not use same name for 2 columns in one table..
It should be unique.
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?
Just Print screen you relevant load statement and useful messages and attach as am image will be enough to give users more context to go on.
Hello,
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.
Thanks