Multi Row Question

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!

Developer

Custom Tools

Dynamic Processing

Accepted answers

All comments

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:

Multi Row Formula.yxmd

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

MultiRow Question - Filter-Join Solution.yxmd

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 : )

comments.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703