Creating a new table from an existing table

[Qlikuser09]

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

[QFabian · Accepted solution]

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

[Gui_Approbato]

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 · Accepted solution]

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