Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Need help to create filter for field Assets with values a,b,c,d. So values a,b,c should be named as A1 and abcd named as B1... A1 and B1 will be a filter field on the frontend. Note.. Field in the data model is Assets..
Appreciate any help in getting script to create this.
Thanks,
M
Not completely clear on your data but on a high level use below syntax in load script.
Load
Assets
, If(wildmatch(Assets,'a','c'),'A1',if(wildmatch(Assets,'b'),'B1') ) as AssetType
Not completely clear on your data but on a high level use below syntax in load script.
Load
Assets
, If(wildmatch(Assets,'a','c'),'A1',if(wildmatch(Assets,'b'),'B1') ) as AssetType
Is sounds like you want to put it in upper case and add a 1 in the end like this:
LOAD
Assets as Assets.original,
Upper(Assets) & '1' as Assets.frontend
FROM
Source ;