How to write a query that references the table created in another section in Data Load Editor

[dominono9]

Hi,

In Data Load Editor

I want to write a query that refferences  the table created in another section(= section1)

but I don't know how to do that. Tell me how to do that.

[deepanshuSh]

Its quite simple, instead of using from [Sale_table1] use Resident TableName; Try to understand more about resident table functionality using qlik help or qlik community as well. 

[dominono9]

Thank you bery much!

I used "RESIDENT" and it worked without error. But only "sales_table1" is generated and not "sales_table2"   as far as the Data Manager

How can "sales_table2" be generated?

[deepanshuSh]

since the both tables are having same field names, they are autoconcatenated, you need to use noconcatenate to see both the tables as individuals. 

[dominono9]

Thank you!!!

I added nonconcatenate and executed.

But a synthetic key occurred and did not produce the intended result.

Hmm😯😕

[MarcoWedel]

please explain what you are trying to achieve with this second table that seems to be just a subset of your initial table.

[dominono9]

Thank you for replying.

I want to keep them separate tables without subsetting.

sales_table1: before being filtered s

ales_tabel2: filtered by where clause

[MayilVahanan]

Hi

If you want to keep separate table without link to the existing table, try with Qualify functionality

Qualify *;

Load *  resident [Sale_table1];

unQualify *;

suppose, you need to link with one field , in ur case, u can rename the second field

[MarcoWedel]

What are you planning to do with sales_table2 that in your opinion requires a separate filtered copy of sales_table1?

[dominono9]

Thank you　@MarcoWedel 

I would like to know how to save before processing and after processing as separate tables.

I would like to be able to track the data editing process step by step like Alteryx and Power Query.

Shouldn't something like that be done in the Data Load Editor?