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: 
Anonymous
Not applicable

How to create a dummy column?

I have 2 tables.

Table A with Columns Server, Status and Type

Table B with Columns Server, Status and Type

I success fully connected to DB and created a straight table object with these 3 columns. Data is displaying correctly.

Now If I want to see the data only from Table A - How to create a selection criteria. I need a button so that I can Select between Table A and Table B so that I could see the Straight Table object with appropriate table data as required.

Any ideas please

1 Solution

Accepted Solutions
sunny_talwar

You can create flags for this:

[Table A]:

LOAD [Columns Server],

          Status,

          Type,

          'A' as TableFlag

From [Source A];

[Table B]:

LOAD [Columns Server],

          Status,

          Type,

          B as TableFlag

From [Source B];

and then use TableFlag to choose between the two tables.

HTH

Best,

Sunny

View solution in original post

4 Replies
sunny_talwar

You can create flags for this:

[Table A]:

LOAD [Columns Server],

          Status,

          Type,

          'A' as TableFlag

From [Source A];

[Table B]:

LOAD [Columns Server],

          Status,

          Type,

          B as TableFlag

From [Source B];

and then use TableFlag to choose between the two tables.

HTH

Best,

Sunny

buzzy996
Master II
Master II

just create a flag on ur table script like Sunny said above and use the same flag from front end selections to see corresponding table data.

Anonymous
Not applicable
Author

No words to appreciate you. Working like a feather. Thanks a ton.

sunny_talwar

Hahaha your most welcome.

Best,

Sunny