Adding a flag to each entry in a Table to identify table name
I'm loading in data from several tables in Qlik Sense from an ORACLE database, e.g. one table called APPLES and another called ORANGES. What I'm trying to do is create a flag called [ASSET TYPE] that would read "Apples" if coming from the APPLES table and "Oranges" if from the ORANGES table to give me one output.
Re: Adding a flag to each entry in a Table to identify table name
many thanks for this suggestion - I had tried using a script similar to what you had suggested but was using double quotes instead of your single ones. I replaced this with single quotes in the SELECT part of the statement, e.g.
'Apples' as [ASSET TYPE] but I'm getting the following error message:
The following error occurred:
Connector reply error: ***
Could this be something to do with the fact that I'm trying to connect directly to an Oracle DB?