Get the specific column base on the date selected

[RichardAlt]

Hi All,

I'm working on my workflow, I'm having a problem to solve the issue.

This is my current workflow. 

This is my expression in Dynamic Select Tool, This workflow is working but I need to get the medical and dental column base on the date selected.

Because now when I run the workflow as analytic and select date only the selected date column will be shown.

I want something like this,

For Ex. I selected the October month.

The output must be the like this,

Dental	Medical	October 2020
15	15	30
12	12	24

It will get also the Dental and Medical column from the left of the selected month.

My current workflow is just getting the month column.

Thanks

[atcodedog05 · Accepted solution]

Hi @RichardAlt 

Here is a workflow for the task.

Output:

Workflow:

It required some data prep.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[RichardAlt]

Hi @atcodedog05 ,

Thanks! This is what I want. 

[atcodedog05]

Happy to help 🙂 @RichardAlt 

Cheers and Happy Analyzing 😀

[arjundelara]

@atcodedog05

Highly Appreciated your effort :). This workflow helps a lot ❤️

Thank you!

[atcodedog05]

Happy to help 🙂 @arjundelara 

Cheers and Happy Analyzing 😀