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.
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
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?
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.
Here is one way.
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.
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.
