cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Get value of field defined in another field

SOLVED
Highlighted
Meteor

Each row of my data has 6 fields for each weekday of the week.

 

NameMonTueWedThuFri
Person a9:00 AM8:30 AM9:00 AM9:00 AM8:30 AM
Person b8:30 AM8:00 AM8:30 AM9:00 AM8:00 AM

 

Let's say this represents the time someone should be coming in each day.

 

On each row (From another source) is the Weekday a report was run. So the data is now:

 

 

NameMonTueWedThuFriDay
Person a9:00 AM8:30 AM9:00 AM9:00 AM8:30 AMTue
Person b8:30 AM8:00 AM8:30 AM9:00 AM8:00 AMTue

 

Every "Day" value will be the same on the report for any given report.

 

I want to be able to retrieve the value of the field defined in "Day" so we'd add another column.....

 

NameMonTueWedThuFriDayShould be in at
Person a9:00 AM8:30 AM9:00 AM9:00 AM8:30 AMTue8:30 AM
Person b8:30 AM8:00 AM8:30 AM9:00 AM8:00 AM

Tue

8:00 AM

 

I could construct a monster "IF" statement in a formula tool, but that seems messy and excessive to me. Is there a better way to get the value of a field specified in another field?

 

Alteryx Certified Partner

Hey @cjames728

 

Try something like this:

 

Should be in at.PNG@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Alteryx Partner

Hi cjames 728,

 

Sadly Alteryx doesn't have an 'INDIRECT' function as excel so, I would suggest something like this.

 

Should be in at.JPG

 

 

 

 

 

 

 

 

 

 

 

Best,

Fernando V.