Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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!