Can we union Two fields values in one list box

Fri, 20 Mar 2015 12:56:53 GMT

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.

Re: Can we union Two fields values in one list box

Gysbert_Wassenaar — Fri, 20 Mar 2015 13:04:26 GMT

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

];