creating field with "Label"

[#1]

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?

[ajaykumar1]

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

[Anonymous · Accepted solution]

use a preload

Load

  *,

'Table 1' as 'table Label';

Select *

from SQL DB;

[MayilVahanan]

Hi

Try like this

Load

  *,

'Table 1' as [Table Label];

Sql Select *

from tablename;

[vinay_hg]

Use Qualify and Unqualify Functions.