question

AWill-6950 avatar image
0 Votes"
AWill-6950 asked KranthiPakala-MSFT commented

Azure Data Flow Visual Expression Builder Multiple conditions using IIF Function

I am trying to search a column for Multiple conditions using the iif function in order to determine result A or result B.

Ex. if Column "Role" is like "Mngr", or "VP", or "Head";
Print 'Manager',
`Otherwise 'Employee'

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @AWill-6950,

Welcome to Microsoft Q&A forum and thanks for your query.

I believe CASE function is better suited for your requirement.

104904-image.png


You can have a Case function expression as below to get the desired output:

 case(
     (upper(Title) == 'MNGR' || upper(Title)=='VP' || upper(Title) =='HEAD'), 'Manager',
     'Employee'
     )


104905-image.png


Hope this helps. Do let us know if you have further query.



Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.



image.png (26.8 KiB)
image.png (61.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AWill-6950,

Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @AWill-6950,

We still have not heard back from you. Just wanted to check if the above suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·