If data contains X move all data to True

Hello,

So, I have three workflows that are similar but each need to run on a unique workflow.

Each sheet has 8 rows of data (all informational and is removed later on in the workflow). Before I remove this information I want to test to see what workflow I should run as you cannot tell what workflow should run without this information.

I tried a filter IF [F2] Contains "X", and it only gives me one line with the text I searched for (this line is not useful to my workflow and will be removed as mentioned above) and all of the rest of the data moves to the False output.

I basically want to test to see if my sheet contains X and if it is True move all data as is on. If false, it will perform another test to see what the appropriate workflow is.

What tools would I utilize to achieve this?

Thanks!!

Preparation

Interface Tools

Accepted answers

Deano478

@kkelly3 so based on what your saying have a look at this and see if it suits your case:

SAMPLE.yxmd

All comments

Raj

@kkelly3 try using

if contains([F2],"X") then "True" else "False"

this should work.

kkelly3

Unfortunately that is not working. When I run that code I only get the one line that contains X resulting in True. The rest of the lines are still going to false.

Deano478

@kkelly3 will the row simply contain just the letter X or is there any other text prefixing it or after it? if its just simply X you can try something like

if Contains([F2], 'X', 0) Then 1 else 0 endif

kkelly3

@Deano478

There is more text in the cell (B3 in the excel sheet I attached below). In this case I am searching to see if it contains "Can".

I attached a sample of the data and the workflow that I am currently working on. Currently the workflow identifies the "Can" row and putting that into the true output and the rest to the false output. Because this sheet contains "Can" my goal is to get everything in the true output.

SAMPLE.xlsx

SAMPLE.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703