Manual Text field in script

[#1]

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

[maxgro]

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;

[AbhijitBansode · Accepted solution]

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.