topic Re: Manual Text field in script in QlikView

Manual Text field in script

Thu, 11 Sep 2014 08:00:25 GMT

I am trying to add a field with that has some fixed text in it:

My thoughts where I could write

"Email" as Table,

but that doesn't seems to work - I'm trying to include it in the select statement as I have two tables that I am concatenating but I want a field that tells me which information is from which table.

Many thanks,

Drew

Re: Manual Text field in script

maxgro — Thu, 11 Sep 2014 08:02:20 GMT

use single quote

Load

'Email' as Table,

.......

EDIT:

to concatenate

t1:

load

'Email' as Table,

.......

from sometable;

concatenate (t1)

load

'AnotherType' as Table,

.......

from someothertable;

Re: Manual Text field in script

AbhijitBansode — Thu, 11 Sep 2014 08:03:11 GMT

Load

'First' as TableNumber;

Concatenate

Load

'Second' as TableNumber;

This TableNumber field in the result table will tel;l you which info is from which table.