1 Reply Latest reply: Mar 20, 2015 9:11 AM by Gysbert Wassenaar RSS

    Can we union Two fields values in one list box

      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

          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

          ];