How do I dynamically select a field based on another field's data?

[akihirokomatsu]

I have a dataset that looks like below. How would I use either "DateTimeNow" or "DateTime_Out" to dynamically select ONLY the "Jun-18", but would choose Aug-18 when the DateTimeNow/DateTime_Out is in August? Any ideas are welcome! Thanks.

[jasperlch]

Hi, would you consider using Cross Tab and Transpose like below:

[neilgallen · Accepted solution]

@akihirokomatsu The "Dynamic Select" tool would suit your purposes. In this instance, set the configuration to be "Select via a Formula."

.

Note that this is setup to choose the current month field and not to your "DateTime_Out" function but if you wanted the previous month adding a datetimeadd function to the beginning would not be difficult.

Also in this case you wouldn't necessarily need the datetimenow or dateimteout fields as alteryx is aware of the current time and can use that in a function.

[akihirokomatsu]

Thank you! This worked very well.

[akihirokomatsu]

Thank you! This is exactly what I needed.