topic Re: Remove cell values based on results/outcome in Alteryx Designer Desktop Discussions

Remove cell values based on results/outcome

ZahinOsman — Fri, 01 Sep 2023 07:36:21 GMT

Hi all,

I'm trying to figure out how to remove certain values in cells when a result is obtained. Eg. if "yes" then values are removed from a couple of cells.

In this case, if "Right_Run++" does not equal "Run++", then the following cells highlighted in red should have their values removed

Run_Description

Batch_Name

Schedule

Region

Re: Remove cell values based on results/outcome

flying008 — Fri, 01 Sep 2023 08:04:58 GMT

Hi, @ZahinOsman

FYI.

IIF([Run++] = [Right_Run++], [_CurrentField_], Null())

Re: Remove cell values based on results/outcome

DataNath — Fri, 01 Sep 2023 08:06:43 GMT

Hey @ZahinOsman, here's how I'd go about this. One of the nice tools in Alteryx is the Multi-Field Formula where we can apply expressions to multiple fields at the same time. For this, we use a simple IF statement of:

IF [Right_Run++] != 'Run++' THEN NULL() ELSE [_CurrentField_] ENDIF

and in the configuration, we tick the fields you want this applied to - [User] through to [Valuation Date] and if the check is satisfied i.e. [Right_Run++] isn't 'Run++' then it'll null these fields. You can add other fields to this check by just ticking them in the configuration list. Workflow attached - hope this helps!

Re: Remove cell values based on results/outcome

ZahinOsman — Sun, 03 Sep 2023 13:34:31 GMT

Hi @DataNath @flying008

I've tried using the formula given, but seems like its removing all the values even if "Right_Run++" equals "Run++"

Referencing the below table, the first 2 columns have Right_Run++ is equal to Run++, denoted by the last cell as True. But its removing all the data I wish to keep (User, Submitted Time, Completed, Time, Progress, Valuation Date)

Run_Description

Batch_Name

Schedule

Region

Re: Remove cell values based on results/outcome

flying008 — Mon, 04 Sep 2023 02:55:50 GMT

Hi, @ZahinOsman

Please follow my formula above.