Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am pulling data from 3 different tables and at the end i am merging all three tables data
to understand which data is from which table i am using a flag and adding it in the merge load script
Table1:
.....
1 as Flag
Table2:
.....
2 as Flag
Table3:
....
3 as Flag
then in my dashboard i am using this Flag as list box
=IF(FLAG=1,'xxx',IF(FLAG=2,'yyy',IF(FLAG=3,'zzz')))
Problem is in the current selection box it is show as
Flag:1 or Flag:2 or Flag:3 based on my selection
I want to display in the current selection box as
xxx , yyy or zzz
How can i achieve it.
use dual
Table1:
.....
Dual('xxx',1) as Flag
Table1:
.....
Dual('yyy',1) as Flag
Hi Ashis:
You can use only one flag with 3 diferentes values 1,2 y 3.
Table1:
...
1 as Flag
....
Table2:
2 as Flag
...
Table3:
3 as Flag
...
Best Regards,
Juan P. Barroso
Hi,
it is still not very clear I think.. would you be able to attach screen shot or sample app to see what you have so far ?
why dont you do this at the script
like Flag as xxx instead of 1
Hi Juan,
Sorry for not being clear from my above statement.
Actually I am doing the same as you said.
Now in the current selection box I see Flag:1 or Flag:2 or Flag:3 as selection , how can I change the display of this .
I want to show Flag:xxx or Flag:yyy or Flag:zzz
Thank you Sudhir,
I want to keep it numeric instead of string value .
Is there any way I can change it in the display of current selection.
Hi Youssef ,
Sorry for the confusion, I have reposted it . Please have a look.
use dual
Table1:
.....
Dual('xxx',1) as Flag
Table1:
.....
Dual('yyy',1) as Flag
You can use codes not numbers:
Table1:
...
'xxx' as Flag
....
Table2:
'yyy' as Flag
...
Table3:
'zzz' as Flag
...
Best Regards,
Juan P. Barroso
Thank you Sasidhar, it worked .