topic Re: How to write Else part in Pick & Match function and why Pick & Match is better than Nested if statement in App Development

How to write Else part in Pick & Match function and why Pick & Match is better than Nested if statement

ManojMJ — Sun, 23 Feb 2025 18:17:01 GMT

How to write Else part in Pick & Match function and why Pick & Match is better than Nested if statement?

Re: How to write Else part in Pick & Match function and why Pick & Match is better than Nested if statement

Vegar — Sun, 23 Feb 2025 22:55:44 GMT

Using pick'n match will be faster as it will only evaluate your match expression once, in nestled if statements it will be evaluated once per if statement.

It is can also be a more condense way of writing your code. It is also easier to increase / decrease the values to compare .

As a no match pick() will retun zero, I often add a +1 to my pick() in order to get a default value.

Pick(1+match(...),'default value', 'value1','value2',...)

Re: How to write Else part in Pick & Match function and why Pick & Match is better than Nested if statement

ali_hijazi — Mon, 24 Feb 2025 07:16:08 GMT

I use the following technique:
pick(WildMatch('$(vAppStreamName)','unpublished','*test*') + 1, your_else_part, value1, value2)

Re: How to write Else part in Pick & Match function and why Pick & Match is better than Nested if statement

rwunderlich — Mon, 24 Feb 2025 16:45:09 GMT

@Vegar

"Using pick'n match will be faster as it will only evaluate your match expression once, in nestled if statements it will be evaluated once per if statement."

I disagree. Last time I tested, every pick() option is evaluated, just as every branch of an if() is evaluated. Did something change or do you have experience to the contrary?

-Rob

Re: How to write Else part in Pick & Match function and why Pick & Match is better than Nested if statement

Vegar — Tue, 25 Feb 2025 20:35:31 GMT

@rwunderlich

This has been my believed known truth for years, so I have not questioned it.

Based on what you are writing here I will withdraw my statement of pick and match being faster, I do however in most cases find it faster to write script using that technique;-)

I interpret your comment as you have found the two to be about equal in term of reload performance. Is that a correct understanding?

Thanks for remarking on my comment.

Re: How to write Else part in Pick & Match function and why Pick & Match is better than Nested if statement

rwunderlich — Tue, 25 Feb 2025 21:34:15 GMT

@Vegar I have not tested performance in a reload script. I have however tested in a chart (confirmed yesterday). I've found the performance to be identical.

-Rob