topic Re: How to perform an IF statement for blank values in Data Movement & Streaming

How to perform an IF statement for blank values

kaylab — Wed, 19 Mar 2025 23:04:08 GMT

I am trying to put "Not Accessed" In the last column for the boxes that contain '-' but nothing works. I've tried numerous IF statements and len but nothing seems to work. It is tied with users first/last name and their emails if that helps. All i need is for LastViewDate to show 'Not Accessed' when there is a blank.

Re: How to perform an IF statement for blank values

Zapparoli — Fri, 23 Jun 2023 21:04:09 GMT

Hi Kaylab.

Those "-" are null values, you can treat them by using IsNull Function.

In your case: If(IsNull(Latest),'Not Accessed', Latest).

You can use this either on your table or directly into the Script.

-Zapparoli

Re: How to perform an IF statement for blank values

kaylab — Mon, 26 Jun 2023 02:29:59 GMT

Thank you for your response but for some reason it is not working in either.

Re: How to perform an IF statement for blank values

MayilVahanan — Mon, 26 Jun 2023 03:48:19 GMT

Can you try with Alt function like

Alt(Latest, 'Not Accessed')

Re: How to perform an IF statement for blank values

kaylab — Mon, 26 Jun 2023 11:46:20 GMT

That's not working either unfortunately.

Re: How to perform an IF statement for blank values

MayilVahanan — Tue, 27 Jun 2023 02:51:06 GMT

Are you implementing the suggestion in front end or back end?