How To Replace NULLS based on condition from 2 other columns

[anuj_Chahal]

The requirement is when there is data in the BUILD request and there comes an UPDATE or UPGRADE with the same name, Platform, TEAM, and Selection should automatically get the same data.

Request	NAME	Platform	TEAM	SELECTION
BUILD	Workflow	CLOUD	ANALYTIC	Transformation
UPDATE	Workflow
BUILD	BI	DIGITAL	Insights	AI
UPDATE	BI
UPGRADE	BI

Output

Request	NAME	Platform	TEAM	SELECTION
BUILD	Workflow	CLOUD	ANALYTIC	Transformation
UPDATE	Workflow	CLOUD	ANALYTIC	Transformation
BUILD	BI	DIGITAL	Insights	AI
UPDATE	BI	DIGITAL	Insights	AI
UPGRADE	BI	DIGITAL	Insights	AI

[Yoshiro_Fujimori · Accepted solution]

@anuj_Chahal ,

One way of doing is 

to Transpose the columns and Summarize (Concatenate) the values together,

which will make Multi-Row Formula tool easier to deal with the copy form the previous row.

I hope this may be of some help.

[anuj_Chahal]

Hi,
Thanks for the solution. May I Know the name of the Last tool used in this workflow?

[Yoshiro_Fujimori]

Do you mean this?

This is "Expect Equal" macro, which is conveniently used to validate the actual output with the expected result.

https://community.alteryx.com/t5/Engine-Works/Crew-Macro-Pack-2016-Q2-Release/ba-p/26482

This tool is widely used in the Weekly Challenge community to test the workflow.

As it is added for test purpose, it is not directly relevant to your business case.

Sorry for the confusion.