Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
hidehuman
Contributor II
Contributor II

How to edit a joined table through data load editor

As I completed joining two existing tables, I wanted to use applymap() to match a column of the newly joined table to a column with another. However, how can I refer to this newly joined table? There are explanations on how to refer to either spreadsheets uploaded to Qlik, or pointing to data sources beyond Qlik, but not this newly edited table. Is there a way to refer to such tables as rectified within Qlik?

Labels (2)
1 Reply
Mark_Little
Luminary
Luminary

You will need to perform a resident load. If doing it straight after start with a noconcatenate as the table will have the same data Qlik will want to concatenate them together, Then drop the first table as you do not want two copies of the table

noconcatenate

Table2:

LOAD

*,

APPLYMAP() AS Thing

Resident Table1;

Drop Table Table2;