Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paulpich69
New Contributor

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
Honored Contributor II

Re: Qlik Sense, Field Uniqueness

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
Valued Contributor

Re: Qlik Sense, Field Uniqueness

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
Honored Contributor III

Re: Qlik Sense, Field Uniqueness

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

It  should be unique.

paulpich69
New Contributor

Re: Qlik Sense, Field Uniqueness

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
Honored Contributor II

Re: Qlik Sense, Field Uniqueness

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.

malejandra
New Contributor

Re: Qlik Sense, Field Uniqueness

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

Community Browser