Selecting only current month

Question

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.

SourceTechnologyRoleLevelProject / Delivery Team TitleProject GroupPlanview Work IDOct-20Nov-20Dec-20Jan-21Feb-21Mar-21Apr-21May-21Jun-21Jul-21Aug-21Sep-21Oct-21Nov-21Dec-21  ModelData EngineerDeveloperDeveloperData 2020 - Claims Roadmap (Claims Exploration)02-20-0082.252.252.251.751.51.51.51.51.51.51.51.51.51.51.5Split based on expected Senior v Dev ModelDataStageDeveloperDeveloperData 2020 - Claims Roadmap (Claims Exploration)02-20-0082.1252.252.2521.61.61.61.61.61.61.61.61.51.51.5Split based on expected Senior v Dev ModelData EngineerDeveloperSeniorData 2020 - Claims Roadmap (Claims Exploration)02-20-00811110.50.50.50.50.50.50.50.50.50.50.5Split based on expected Senior v Dev ModelDataStageDeveloperSeniorData 2020 - Claims RoadmapClaims Roadmap (Claims Exploration)02-20-00811110.50.50.50.50.50.50.50.50.50.50.5Split based on expected Senior v Dev ModelDataStageDeveloperDeveloperData 2020 – Data WindowData Window02-20-0130001.32.52.52.52.52.52.52.52.52.52.52.5  ModelDataStageDeveloperDeveloperData 2020 – EDW as a ServiceEDW as a Service02-20-01200002.52.52.52.52.52.52.52.52.52.52.4  ModelDataStageDeveloperSeniorData 2020 – EDW as a ServiceEDW as a Service02-20-012000011111111111  ModelData EngineerDeveloperDeveloperData 2020 – Fix Forward Data PipelinesFix Forward Data Pipelines (FFDP)02-20-01133344.44.34.34.34444444Taken from Angus spreadsheet ModelDataStageDeveloperDeveloperData 2020 – Fix Forward Data PipelinesFix Forward Data Pipelines (FFDP)02-20-011111111111111111Taken from Angus spreadsheet ModelData EngineerDeveloperSeniorData 2020 – Fix Forward Data PipelinesFix Forward Data Pipelines (FFDP)02-20-0110000.922222222222Currently, vacancies being recruited ModelDataStageDeveloperDeveloperData 2020 – Master & Reference Data ManagementMaster & Reference Data Management02-20-0100001.91.91.91.91.91.91.91.91.91.91.91.9  PMAlteryxDeveloperDeveloperData 2020 – Pricing Data ProvisioningPricing Data Provisioning02-20-009000111100000000For Salesforce data PMDataStageDeveloperDeveloperData 2020 – Pricing Data ProvisioningPricing Data Provisioning02-20-0090001.51.51.51.51.51.51.51.51.51.51.51.5  PMNaturalDeveloperDeveloperData 2020 – Pricing Data ProvisioningPricing Data Provisioning02-20-0090.50.50.50.50.50.50.50.50.50.50.50.50.50.50.5  PMOracleDeveloperDeveloperData 2020 – Pricing Data ProvisioningPricing Data Provisioning02-20-0090000.20.20.3000000000Added after discussion with PM PMSASDeveloperDeveloperData 2020 – Pricing Data ProvisioningPricing Data Provisioning02-20-00966.356.356.97.46.56.56.86.86.86.86.86.86.86.8

atcodedog05 · Answer

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

current month (2).yxmd

rohini · Answer

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 · Answer

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

current month2.yxmd