Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Get value of field defined in another field

cjames728
7 - 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?

 

2 REPLIES 2
LordNeilLord
15 - Aurora

Hey @cjames728

 

Try something like this:

 

Should be in at.PNG@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

fevizcaino
5 - Atom

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.

Labels