Prob in Script

[nikhilgarg]

Hey,

In my dashboard, i am fetching data from OLEDB source. Now, there is a Field "BusinessGroup" in databse.

Now if BusinessGroup = 'ABC%' Then ABC else fetch Desk field values from flat file.

How can i do this in script??

[PrashantSangle]

Hi,

Just simply use wildmatch() or match() with wildcharacter *

try like

if(wildmatch(BusinessGroup),'ABC*','ABC',DeskField) as new_DeskField

Use wildmatch() if you want to non case sensitive search

and

Use match() if you want to case sensitive search

Regards

[#3]

hi,

=if(wildmatch( FIELD1, 'ABC*')  as  Flag

it returns 1,0 ----1 means data which will be start from ABC

0-means other than ABC

Regards

Vimlesh