Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
No words to appreciate you. Working like a feather. Thanks a ton.
Hahaha your most welcome.
Best,
Sunny