Get the specific column base on the date selected

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

Get Column.yxwz

Workflow

Output

Accepted answers

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 😀👍

Get Column.yxwz

All comments

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 😀👍

Get Column.yxwz

Hi @atcodedog05 ,

Thanks! This is what I want.

Quick Links

Tags

This months top contributors

Hollingsworth 335