Multiple select box

[#1]

Hi;

How I can make a multiple select box from this LOAD:

sites:

LOAD

  if(WildMatch5(NAME, '*NAME1*'), 'Brand1') as [Brand1],

  if(WildMatch5(NAME, '*NAME2*'), 'Brand2') as [Brand2],

  if(WildMatch5(NAME, '*NAME3*'), 'Brand3') as [Brand3],

  if(WildMatch5(NAME, '*NAME4*'), 'Brand4') as [Brand4],

  if(WildMatch5(NAME, '*NAME4*'), 'Brand5') as [Brand5],

  if(WildMatch5(NAME, '*NAME5*'), 'Brand6') as [Brand6]

FROM

C:\sites.qvd(qvd)

[MK_QSL]

LOAD

Pick(WildMatch(NAME,'*NAME1*','*NAME2*','*NAME3*','*NAME4*','*NAME5*'), [Brand1],[Brand2],[Brand3],[Brand4],[Brand5]) as FieldName

From

C:\sites.qvd(qvd);

UPDATE : I have updated Pick instead of IF

[#3]

Manish Kachhia
How I can solve this issue?

Error in expression:

If takes 2-3 parameters

sites:

LOAD SITE_ID,

     NAME,

     IF(WildMatch(NAME,'*NAME1*','*NAME2*','*NAME3*','*NAME4*','*NAME5*'), [Brand1],[Brand2],[Brand3],[Brand4],[Brand5]) as FieldName

[MK_QSL · Accepted solution]

I have updated....

Use Pick Instead of If

PICK(WildMatch(NAME,'*NAME1*','*NAME2*','*NAME3*','*NAME4*','*NAME5*'), [Brand1],[Brand2],[Brand3],[Brand4],[Brand5]) as FieldName

[#5]

Perfect Manish Kachhia, thank for your help...

This is the final sentence:

Pick(WildMatch(NAME,'*NAME1*','*NAME2*','*NAME3*','*NAME4*','*NAME5*'), 'Brand1','Brand2','Brand3','Brand4','Brand5') as FieldName