Synthetic Key: Two almost identical tables with same field name

[PamelaAlcantara]

Hi,

I am trying to load 3 tables from Teradata. Two of those tables are huge and contain the same name in almost every field (around 60 fields each). When I try to load the data, it takes more than one hour and then I get the error that same something went wrong. 

I believe it is because Qlik Sense is creating synthetic keys for each field that share the same name and as I mentioned there are many.

Is there a way to change the name of each field before loading the data? So Qlik doesn't create all those synthetic keys?

I already tried the following, but I keep getting an error

LOAD
[Item_ID] AS [R_Item_ID],
[Case_ID] AS [R_Case_ID],

etc,

Does anyone know how to avoid the creation of synthetic keys by renaming name fields?

Thank you in advance!

Pamela

[Saravanan_Desingh · Accepted solution]

Try with

QUALIFY *;

[Tanalex · Accepted solution]

QUALIFY 

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegular...

It prepends the table name to the column name.  You can then UNQUALIFY the key field(s), so it does not get the table name prepended to it and can be the join column.

[Vegar]

As earlier replies sai , QUALIFY, is a way to go.

An alternative solution to consider is to concatenate the two data sets into one larger transaction table. 

[Beneliasq]

Agree with the replies above, and you could try something like this.

Qualify *;

UnQualify [Key fields]; //if there are any key fields on which the association should happen

Table1:

Load statement;

Table2:

Load statement;

UnQualify *;

[marksouzacosta]

Hi Pamela,

We just released a new video in our YouTube channel related to your question.
I hope it helps!

IPC Tips - Removing Synthetic Keys
https://youtu.be/tETUxntiqew

Regards,

Mark Costa