Get value of field defined in another field

[cjames728]

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

Name	Mon	Tue	Wed	Thu	Fri
Person a	9:00 AM	8:30 AM	9:00 AM	9:00 AM	8:30 AM
Person b	8:30 AM	8:00 AM	8:30 AM	9:00 AM	8: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:

Name	Mon	Tue	Wed	Thu	Fri	Day
Person a	9:00 AM	8:30 AM	9:00 AM	9:00 AM	8:30 AM	Tue
Person b	8:30 AM	8:00 AM	8:30 AM	9:00 AM	8:00 AM	Tue

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.....

Name	Mon	Tue	Wed	Thu	Fri	Day	Should be in at
Person a	9:00 AM	8:30 AM	9:00 AM	9:00 AM	8:30 AM	Tue	8:30 AM
Person b	8:30 AM	8:00 AM	8:30 AM	9:00 AM	8: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?

[LordNeilLord · Accepted solution]

Hey @cjames728

Try something like this:

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[fevizcaino · Accepted solution]

Hi cjames 728,

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

Best,

Fernando V.