Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;