Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
I have updated....
Use Pick Instead of If
PICK(WildMatch(NAME,'*NAME1*','*NAME2*','*NAME3*','*NAME4*','*NAME5*'), [Brand1],[Brand2],[Brand3],[Brand4],[Brand5]) as FieldName
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
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
I have updated....
Use Pick Instead of If
PICK(WildMatch(NAME,'*NAME1*','*NAME2*','*NAME3*','*NAME4*','*NAME5*'), [Brand1],[Brand2],[Brand3],[Brand4],[Brand5]) as FieldName
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