How to write If --else if--- statement in Azure Mapping Data Flow Expression

Swapnil Kalkar 66

Hello I am new to Azure Mapping data flows?

I wanted write expression in mapping dataflows equivalent to

If ( Account = 'A100')
Then 'Normal'
Else If (Account='B200')
Then 'Gross'

How I can write above logic in mapping data flows expression?
Appreciate your help here.

@MarkKromer-8019 @PRADEEPCHEEKATLA-MSFT

KranthiPakala-MSFT 46,507 Reputation points Microsoft Employee

2021-01-28T19:27:59.113+00:00

Hi @Anonymous ,

Following up to see if the below suggestion from Mark Kromer was helpful to achieve your requirement? if it's helpful, please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.

And if you have further query on the same, please do let us know.

Thank you
KranthiPakala-MSFT 46,507 Reputation points Microsoft Employee

2021-01-29T19:41:10.293+00:00

Hi @Anonymous ,

We still have not heard back from you. Just wanted to check if you are still looking for assistance on this requirement?

----------

Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

Accepted answer

Mark Kromer MSFT 1,146 Reputation points

2021-01-27T19:08:33.997+00:00

Use a Derived Column transformation. Pick the Account column to transform and in the expression, type this:

iif (Account == 'A100','Normal',iif(Account=='B200','Gross',Account))

... or use case(), which I think is cleaner:

case(
Account == 'A100', 'Normal',
Account == 'B200', 'Gross'
)
Please sign in to rate this answer.

2 people found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer