Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concat tables - still synthetic keys

Hi,

i am trying to concat some files into one table called "Kategorie". I hoped the script is complete, but i´ve still synthetic keys

I can´t find the fault, could anybody help me?

1 Solution

Accepted Solutions
boorgura
Specialist
Specialist

You are resuing the same table name for multiples uses (which internally gets renamed in QVW)

try this:

KategoryFinal:

NoContatenate LOAD * Inline [

Datum, Anzahlk, Schlussel, Quelle

];

Sub ContatenateKategorie(vFile)

Kategorie:

LOAD ...

..

from $(vFile) ;

Concatenate(KategoryFinal)

LOAD * RESIDENT Kategorie;

DROP TABLE Kategorie;

END SUB

View solution in original post

2 Replies
boorgura
Specialist
Specialist

You are resuing the same table name for multiples uses (which internally gets renamed in QVW)

try this:

KategoryFinal:

NoContatenate LOAD * Inline [

Datum, Anzahlk, Schlussel, Quelle

];

Sub ContatenateKategorie(vFile)

Kategorie:

LOAD ...

..

from $(vFile) ;

Concatenate(KategoryFinal)

LOAD * RESIDENT Kategorie;

DROP TABLE Kategorie;

END SUB

Not applicable
Author

Great! It is going nicely.

Thank you very much!