topic Re: creating field with "Label" in QlikView

creating field with "Label"

Fri, 12 Sep 2014 09:48:46 GMT

I am concatenating two tables but would like to create a field that says which table the information has come from.

I thought something like:

'Table 1' as 'Table Label'

However I am loading from an SQL select and "Table 1" is not a field that exists. Is there a way to add manual text and not try to pick up a field from the table?

Re: creating field with "Label"

ajaykumar1 — Fri, 12 Sep 2014 09:51:41 GMT

Hi,

As per my understanding;

you have the multiple data sources you want to identify the fields are coming from which table.To achieve this we have to use some flag creation like below.

'Table 1 ' as Table_Label

Re: creating field with "Label"

Anonymous — Fri, 12 Sep 2014 09:52:34 GMT

use a preload

Load

'Table 1' as 'table Label';

Select *

from SQL DB;

Re: creating field with "Label"

MayilVahanan — Fri, 12 Sep 2014 09:55:41 GMT

Try like this

Load

'Table 1' as [Table Label];

Sql Select *

from tablename;

Re: creating field with "Label"

vinay_hg — Fri, 12 Sep 2014 09:58:33 GMT

Use Qualify and Unqualify Functions.