topic Re: Adding a flag to each entry in a Table to identify table name in QlikView

Adding a flag to each entry in a Table to identify table name

Anonymous — Wed, 08 Mar 2017 16:32:46 GMT

Hi,

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.

Any ideas how I might create something like this?

Many thanks,

Sarah

ASSET ID	ASSET TYPE	ASSET NAME	REGION	COUNTRY
X1234	Apples	Granny Smith	EMEA	UK
X0154	Apples	Pink Lady	EMEA	Spain
X1857	Oranges	Satsuma	LATAM	Brazil
X1095	Oranges	Mandarin	EMEA	Spain

LIB CONNECT TO [Oracle_abc.com]

[APPLES]:

LOAD [ASSET ID]

,[ASSET NAME]

,[REGION]

,[COUNTRY]

; SELECT "ASSET ID"

,"ASSET NAME"

,"REGION"

,"COUNTRY"

FROM APPLES;

[ORANGES}:

LOAD [ASSET ID]

,[ASSET NAME]

,[REGION]

,[COUNTRY]

; SELECT "ASSET ID"

,"ASSET NAME"

,"REGION"

,"COUNTRY"

FROM ORANGES;

Re: Adding a flag to each entry in a Table to identify table name

sunny_talwar — Wed, 08 Mar 2017 16:35:43 GMT

May be like this

[APPLES]:

LOAD [ASSET ID]

,[ASSET NAME]

,[REGION]

,[COUNTRY]

; SELECT "ASSET ID"

,"ASSET NAME"

,"REGION"

,"COUNTRY"

,'Apples' as [ASSET TYPE]

FROM APPLES;

[ORANGES}:

LOAD [ASSET ID]

,[ASSET NAME]

,[REGION]

,[COUNTRY]

; SELECT "ASSET ID"

,"ASSET NAME"

,"REGION"

,"COUNTRY"

,'Oranges' as [ASSET TYPE]

FROM ORANGES;

Re: Adding a flag to each entry in a Table to identify table name

Anonymous — Wed, 08 Mar 2017 17:00:35 GMT

Hi Sunny,

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?

Many thanks,

Sarah

Re: Adding a flag to each entry in a Table to identify table name

sunny_talwar — Wed, 08 Mar 2017 17:01:34 GMT

Are you doing Direct Discovery?

Re: Adding a flag to each entry in a Table to identify table name

Anonymous — Wed, 08 Mar 2017 17:24:35 GMT

Hello Sarah, check the syntax for a missing square-brace that wraps the table name.

Sarah Kebbell wrote:

[ORANGES}: //<~ missing end square-brace

LOAD [ASSET ID]

,[ASSET NAME]

,[REGION]

,[COUNTRY]

; SELECT "ASSET ID"

,"ASSET NAME"

,"REGION"

,"COUNTRY"

FROM ORANGES;