Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Can we union Two fields values in one list box?
Lets say if I have two fields F2 and F3 whit list values F2(1,2,3,4), F3(5,6,7).
I need to display 1,2,3,4,5,6,7 in one list box.
can we manage to do this using expression in list box?
Please find the attached qvw.
Thanks & Regards,
MVV Satish.
Yes, and it will be totally useless:
=ValueList($(=Concat({1<F2={'*'}>}Distinct chr(39) & F2 & chr(39), ',') & ',' & Concat({1<F3={'*'}>}Distinct chr(39) & F3 & chr(39), ',') ))
Concatenate your two tables in the script:
Tab:
LOAD *, 'Tab1' as Source INLINE [
F1, F2
V, 1
V, 2
V, 3
V, 4
];
LOAD F1, F3 as F2, 'Tab2' as Source INLINE [
F1, F3
B, 5
B, 6
B, 7
];
Yes, and it will be totally useless:
=ValueList($(=Concat({1<F2={'*'}>}Distinct chr(39) & F2 & chr(39), ',') & ',' & Concat({1<F3={'*'}>}Distinct chr(39) & F3 & chr(39), ',') ))
Concatenate your two tables in the script:
Tab:
LOAD *, 'Tab1' as Source INLINE [
F1, F2
V, 1
V, 2
V, 3
V, 4
];
LOAD F1, F3 as F2, 'Tab2' as Source INLINE [
F1, F3
B, 5
B, 6
B, 7
];