Remove cell values based on results/outcome

[ZahinOsman]

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

Category

Run Today?

User

Submitted Time

Completed Time

Progress

Valuation Date

Right_Run++

Deleted Run

Run++

Count

Check Run

LondonClose_LDB_1F

IBMO_FX_LDN_Amends

Daily

Singapore

FX Amends

Yes

SYSRNABORPDN1

8/31/2023 17:05

8/31/2023 17:29

FinishedSuccess

8/31/2023

BoogieWoogie

No

Chunkymonkey

1

Yes

Ideally, final result should look like this;

Run_Description

Batch_Name

Schedule

Region

Category

Run Today?

User

Submitted Time

Completed Time

Progress

Valuation Date

Right_Run++

Deleted Run

Run++

Count

Check Run

LondonClose_LDB_1F

IBMO_FX_LDN_Amends

Daily

Singapore

FX Amends

Yes

BoogieWoogie

No

Chunkymonkey

1

Yes

[flying008]

Hi, @ZahinOsman 

FYI.

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

[DataNath]

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!

[ZahinOsman]

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

Category

Run Today?

User

Submitted Time

Completed Time

Progress

Valuation Date

Right_Run++

Deleted Run

Run++

Count

Check Run

Match?

APACClose/IVC_FXO/ASIA_Onsmile_ME_IVC

FXO_APAC_ME_IVC

Monthly (Monthend)

Singapore

FX Main Risk

No

APACClose/IVC_FXO/ASIA_Onsmile_ME_IVCFXO_APAC_ME_IVCapaccloseonsmile_coreAPACClose/RunDefinition/IVC_FXO/ASIA_Onsmile_ME_IVC

No

APACClose/IVC_FXO/ASIA_Onsmile_ME_IVCFXO_APAC_ME_IVCapaccloseonsmile_coreAPACClose/RunDefinition/IVC_FXO/ASIA_Onsmile_ME_IVC

1

No

TRUE

LondonClose/IVC_FXO/LDB_1F_ME_IVC

FXO_LDN_LDB_ME_IVC

Monthly (Monthend)

Singapore

FX Main Risk

No

LondonClose/IVC_FXO/LDB_1F_ME_IVCFXO_LDN_LDB_ME_IVClondonclose1f_coreLondonClose/RunDefinition/IVC_FXO/LDB_1F_ME_IVC

No

LondonClose/IVC_FXO/LDB_1F_ME_IVCFXO_LDN_LDB_ME_IVClondonclose1f_coreLondonClose/RunDefinition/IVC_FXO/LDB_1F_ME_IVC

1

No

TRUE

LondonClose_LDB_1F

IBMO_FX_LDN_Amends

Daily

Singapore

FX Amends

Yes

BoogieWoogie

No

Chunkymonkey

1

Yes

FALSE

[flying008]

Hi, @ZahinOsman 

Please follow my formula above.