Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense, Field Uniqueness

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

6 Replies
ogster1974
Partner - Master II
Partner - Master II

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.

eduardo_sommer
Partner - Specialist
Partner - Specialist

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

shraddha_g
Partner - Master III
Partner - Master III

You can not use same name for 2 columns in one table..

It  should be unique.

Anonymous
Not applicable
Author

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?

ogster1974
Partner - Master II
Partner - Master II

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.

Anonymous
Not applicable
Author

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