Help: Identify user response

[sabihaS]

Hello Everyone,

I have a scenario where requirement is to fetch user response from a column(single cell) e.g. I should be able to extract 6  as user response. Please can you advise?

col1

1 2 3 4 5 6 7 8 9 10
                     x

Thank you in advance.

[ChrisTX]

Are you trying to read data from Excel?

Is there one column, with 3 rows?  

Does the example data you posted exactly match the actual input?  Would a sample Excel file be a better representation of the actual input?

[sabihaS]

Yes, extracting from excel file 1 column 1 row. I am attaching sample excel file and screenshot from Alteryx how data is read. Thank you.

[ChrisTX · Accepted solution]

The attached workflow should get you started.  You'll need to do a little more work for cases where the "x" is linked to a response with two digits or more.

 

Chris

[cjaneczko]

Here is one way. 

[sabihaS]

Thank you @cjaneczko for replying. However, when I am testing the flow I am getting 8 as response however it should be 9, I am not able to figure out what needs to be modify to fetch correct response. 

[cjaneczko]

Glad you were able to get a solution. In your Screen cap and sample the X was under the 8. That was what I had worked with to build the above workflow.