Remove cell values based on results/outcome

Question

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_DescriptionBatch_NameScheduleRegionCategoryRun Today?UserSubmitted TimeCompleted TimeProgressValuation DateRight_Run++Deleted RunRun++CountCheck RunLondonClose_LDB_1FIBMO_FX_LDN_AmendsDailySingaporeFX AmendsYesSYSRNABORPDN18/31/2023 17:058/31/2023 17:29FinishedSuccess8/31/2023BoogieWoogieNoChunkymonkey1Yes

Ideally, final result should look like this;

Run_DescriptionBatch_NameScheduleRegionCategoryRun Today?UserSubmitted TimeCompleted TimeProgressValuation DateRight_Run++Deleted RunRun++CountCheck RunLondonClose_LDB_1FIBMO_FX_LDN_AmendsDailySingaporeFX AmendsYes     BoogieWoogieNoChunkymonkey1Yes

flying008 · Answer

Hi, @ZahinOsman

Please follow my formula above.

ZahinOsman · Answer

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_DescriptionBatch_NameScheduleRegion CategoryRun Today?UserSubmitted TimeCompleted TimeProgressValuation DateRight_Run++Deleted RunRun++CountCheck RunMatch?APACClose/IVC_FXO/ASIA_Onsmile_ME_IVCFXO_APAC_ME_IVCMonthly (Monthend)SingaporeFX Main RiskNo     APACClose/IVC_FXO/ASIA_Onsmile_ME_IVCFXO_APAC_ME_IVCapaccloseonsmile_coreAPACClose/RunDefinition/IVC_FXO/ASIA_Onsmile_ME_IVCNoAPACClose/IVC_FXO/ASIA_Onsmile_ME_IVCFXO_APAC_ME_IVCapaccloseonsmile_coreAPACClose/RunDefinition/IVC_FXO/ASIA_Onsmile_ME_IVC1NoTRUELondonClose/IVC_FXO/LDB_1F_ME_IVCFXO_LDN_LDB_ME_IVCMonthly (Monthend)SingaporeFX Main RiskNo     LondonClose/IVC_FXO/LDB_1F_ME_IVCFXO_LDN_LDB_ME_IVClondonclose1f_coreLondonClose/RunDefinition/IVC_FXO/LDB_1F_ME_IVCNoLondonClose/IVC_FXO/LDB_1F_ME_IVCFXO_LDN_LDB_ME_IVClondonclose1f_coreLondonClose/RunDefinition/IVC_FXO/LDB_1F_ME_IVC1NoTRUELondonClose_LDB_1FIBMO_FX_LDN_AmendsDailySingaporeFX AmendsYes     BoogieWoogieNoChunkymonkey1YesFALSE

DataNath · Answer

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!

Null fields based on Run++.yxmd