community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

read and store a value

Meteoroid

Hi All, 

 

I want to read from an excel sheet and store a specific value from the excel sheet to compare it to another value later on in my process. My problem is the position and the value  of what I want to capture and store can be  different each time but the word  "sum"  is a constant  and is always one column and cell to the right of the value, how can I dynamically read and store the value after sum. I have attached an example below 

Bolide
Bolide

If i understand correctly, you have a sheet with 2 columns and you need to pull in "SUM" row. Then take the value to the right?

image.pngInputimage.pngWorkflow "[List] = 'sum'"image.pngOutput - F2 is your field/value you need to carry through

 

Then you can just append F2 (or rename with a select tool) to any dataset coming in to use the value.

Meteoroid

Thank you so much. This was very helpful. Sum can be anywhere in the excel sheet, it can appear in a column that is not F2 or a column that has no name in that case what would I do?

Bolide
Bolide

image.png

I've attached the workflow for the above example. 

First, set the input to "first row contains data" so that it comes back with the generic F1, F2, F3... headers and add a recordID - these two numbers will be our coordinates. 

Then transpose so we can search all cell values for "SUM"

assuming we need 1 cell to the right, add 1 to the "Name" field to reference the column to the right (according to excel).

Then join to the other records and you'll get your desired value. 

Labels