Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

creating field with "Label"

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?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

use a preload

Load

  *,

'Table 1' as 'table Label';

Select *

from SQL DB;

View solution in original post

4 Replies
ajaykumar1
Creator III
Creator III

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
Not applicable
Author

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;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
vinay_hg
Creator III
Creator III

Use Qualify and Unqualify Functions.