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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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!