Multi Row Question

[TheBIguy]

Hello All,

I am confused in setting up a logic.

I have two rows and I need to take only one of them and if that one is not available then the second.

So if it contains "Correction Needed" in comment column then this row else the "No Correction Needed" row

F1	FileName	Value	Comment
Name	x		No Correction Needed
Name	y	09/31/2020	Correction Needed

Thanks in advance!

[TheBIguy]

@atcodedog05 and @Sebastiaandb 

Any help on this?

[JoeHerbert]

Hi @TheBIguy I added a sample row to your table above: xyz, x,' ', 'No Correction Needed' 

And created a flow using a mixture of Multi Row Formula, Summarize and Join to bring back what you are after: 

 becomes: 

[Maskell_Rascal]

Hi @TheBIguy 

If field "F1" can be used as a unique identifier, then you can do this without a Multi-Row formula. 

Filter on comment where value does not contain the word "No", Join the T/F results to find duplicate entries, and then Union the right output of the Join to the true output of the Filter tool. 

Let me know if this works for you. 

Cheers!

Phil

[atcodedog05]

Hi @TheBIguy 

My take on this. Sort comment by ascending so that "Correction needed" comes first then "No Correction needed" then sample out first row. This way if "Correction needed" exists then its selected if not "No Correction needed" is selected.

Workflow:

Hope this helps : )

[TheBIguy]

@atcodedog05 

and if the correction needed cell wont generate then it would delete the one single row too that is No correction needed, But I need that row too.

[atcodedog05]

Hi @TheBIguy 

Can you provide the expected output I can design accordingly.

[TheBIguy]

@atcodedog05 

Ok, Lets make it easy to understand.

I have a file to check where if there is any blank dates it should say No Correction needed but if it has then it should say Correction needed after filtering the this all data. I have this remaining now if file needs correction then only "Correction Needed" row should pickup as the value column has to be checked in that particular FileName. But if it's good then it wont generate any row so I added this new row sayin "No correction Needed" Now if there is any correction we have two rows and if we are getting "Correction Needed" then we don't need "No Correction Needed"

F1	FileName	Value	Comment
Name	x		No Correction Needed
Name	x	09/31/2020	Correction Needed

[atcodedog05]

Hi @TheBIguy 

Lets say your input is like below

F1	FileName	Value	Comment
Jim	z		No Correction Needed
Jim	y	09/31/2020	Correction Needed
John	x		No Correction Needed
Pete	x	09/31/2020	Correction Needed
Pete	y		No Correction Needed

Is below the correct output if not can you provide me the exact output

Hope this helps : )