Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser201
Creator
Creator

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 II
Specialist II

Hi @Qlikuser201 , 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 II
Specialist II

Hi @Qlikuser201 , 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

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))

 

View solution in original post