Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

Creating a new table from an existing table

I tried creating a new table from the existing table based on some conditions, however, I was able to create only one table and not the second one.

Table 1:

Load

Field 1, 

field 2,

Resident (Basetable)

where WildMatch([Field 1], $(vmain))

Table 2 :

Load

Field 1, 

field 2,

Resident (Basetable)

where WildMatch([Field 1], $(vsub))

 

 

2 Solutions

Accepted Solutions
QFabian
Specialist III
Specialist III

Hi @Qlikuser09 , try changing the names in the second load, otherwise, autoconcatenate is in action.

Table 2 :

Load

Field 1   as Field11, 

field 2,

Resident (Basetable)

where WildMatch([Field 1], $(vsub))

QFabian

View solution in original post

maxgro
MVP
MVP

Another option is to use noconcatenate, as described here 

Preventing concatenation of tables 

In your script

Table 2 :

Noconcatenate Load

Field 1, 

field 2,

Resident (Basetable)

where WildMatch([Field 1], $(vsub))

 

View solution in original post

3 Replies
QFabian
Specialist III
Specialist III

Hi @Qlikuser09 , try changing the names in the second load, otherwise, autoconcatenate is in action.

Table 2 :

Load

Field 1   as Field11, 

field 2,

Resident (Basetable)

where WildMatch([Field 1], $(vsub))

QFabian
Gui_Approbato
Creator III
Creator III

Hi, 
You can do like QFabian mentioned specially for consuming the data, or you can use the NoConcatenate to keep both tables separated (if you want to export it using a Store, for example).

Do like:

Table 1:

Load * ...
Noconcatenate

Table2:

Load * ...

maxgro
MVP
MVP

Another option is to use noconcatenate, as described here 

Preventing concatenation of tables 

In your script

Table 2 :

Noconcatenate Load

Field 1, 

field 2,

Resident (Basetable)

where WildMatch([Field 1], $(vsub))