* does not work at resident table

[coloful_architect]

I have table A and table B, wanna append table B into table A and create a final table C with a conditional filter set at one filed at table B;  here is what I have now 

Table A:

load

field one

filed two

filed three

left Join Table B:

load 

field one

field four ( the one I wanna set a condition)

Table C:

load *

resident table A

where field four ="xxx"

drop Table A

it results in nothing....no table and data loaded....but it works if I list all those fields rather than simply using star * ...

but wondering why?  why  * here does not work ? is * supposed to get me all fields ?

or maybe there is a smarter way? all I need is to stack table B into table A and from there to set a condition filter on the field at table B.

thanks 

[Or · Accepted solution]

When you load * from a resident, what will happen is that this will result in the exact same list of fields. When Qlik sees that, it assumes this is the same table and the results will be concatenated. Therefor, in this scenario, you want to use

TableC:

NOCONCATENATE Load *

Resident table A;