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