Selecting only current month

[rohini]

Hi All,

I need to select only the current month data from the  below file and it will be scheduled workflow to run. so the data should be picked automatically.

Can you please help on this as soon as possible.

Source	Technology	Role	Level	Project / Delivery Team Title	Project Group	Planview Work ID	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21
Model	Data Engineer	Developer	Developer	Data 2020 -	Claims Roadmap (Claims Exploration)	02-20-008	2.25	2.25	2.25	1.75	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5	Split based on expected Senior v Dev
Model	DataStage	Developer	Developer	Data 2020 -	Claims Roadmap (Claims Exploration)	02-20-008	2.125	2.25	2.25	2	1.6	1.6	1.6	1.6	1.6	1.6	1.6	1.6	1.5	1.5	1.5	Split based on expected Senior v Dev
Model	Data Engineer	Developer	Senior	Data 2020 -	Claims Roadmap (Claims Exploration)	02-20-008	1	1	1	1	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	Split based on expected Senior v Dev
Model	DataStage	Developer	Senior	Data 2020 - Claims Roadmap	Claims Roadmap (Claims Exploration)	02-20-008	1	1	1	1	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	Split based on expected Senior v Dev
Model	DataStage	Developer	Developer	Data 2020 – Data Window	Data Window	02-20-013	0	0	0	1.3	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5
Model	DataStage	Developer	Developer	Data 2020 – EDW as a Service	EDW as a Service	02-20-012	0	0	0	0	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.4
Model	DataStage	Developer	Senior	Data 2020 – EDW as a Service	EDW as a Service	02-20-012	0	0	0	0	1	1	1	1	1	1	1	1	1	1	1
Model	Data Engineer	Developer	Developer	Data 2020 – Fix Forward Data Pipelines	Fix Forward Data Pipelines (FFDP)	02-20-011	3	3	3	4	4.4	4.3	4.3	4.3	4	4	4	4	4	4	4	Taken from Angus spreadsheet
Model	DataStage	Developer	Developer	Data 2020 – Fix Forward Data Pipelines	Fix Forward Data Pipelines (FFDP)	02-20-011	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	Taken from Angus spreadsheet
Model	Data Engineer	Developer	Senior	Data 2020 – Fix Forward Data Pipelines	Fix Forward Data Pipelines (FFDP)	02-20-011	0	0	0	0.9	2	2	2	2	2	2	2	2	2	2	2	Currently, vacancies being recruited
Model	DataStage	Developer	Developer	Data 2020 – Master & Reference Data Management	Master & Reference Data Management	02-20-010	0	0	0	1.9	1.9	1.9	1.9	1.9	1.9	1.9	1.9	1.9	1.9	1.9	1.9
PM	Alteryx	Developer	Developer	Data 2020 – Pricing Data Provisioning	Pricing Data Provisioning	02-20-009	0	0	0	1	1	1	1	0	0	0	0	0	0	0	0	For Salesforce data
PM	DataStage	Developer	Developer	Data 2020 – Pricing Data Provisioning	Pricing Data Provisioning	02-20-009	0	0	0	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5
PM	Natural	Developer	Developer	Data 2020 – Pricing Data Provisioning	Pricing Data Provisioning	02-20-009	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5
PM	Oracle	Developer	Developer	Data 2020 – Pricing Data Provisioning	Pricing Data Provisioning	02-20-009	0	0	0	0.2	0.2	0.3	0	0	0	0	0	0	0	0	0	Added after discussion with PM
PM	SAS	Developer	Developer	Data 2020 – Pricing Data Provisioning	Pricing Data Provisioning	02-20-009	6	6.35	6.35	6.9	7.4	6.5	6.5	6.8	6.8	6.8	6.8	6.8	6.8	6.8	6.8

[PhilipMannering]

Hi @rohini 

I think you need to pivot the data and use the Filter Tool. See a solution below,

[atcodedog05]

Hi @rohini 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

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

[atcodedog05]

Hi @rohini 

Here is a workflow for the task using a advance tool.

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

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

[rohini]

Thank you this would work bu the file has the date format of 2020/11/01 for the month of November. and goes on so the format needs to be changed.

Regards

rohini

[atcodedog05]

Hi @rohini 

Here is a workflow for the task. 

Input:

Output:

Slash is changed to - in column name

Hope this helps 🙂 Feel to ask if you have any questions

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