Data Transformation to the Desired Format
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi al,
Can anyone help me to get the Desired Output Format as attached in the workflow.
- The Required input Data is provided
- The Designation mapping Sheet is Given
- The Required output Format is Provided only for the BU = AWM and Designation From Director to Manager Level. Similarly we need the output of the count for all BU and All Designation. in the same format.
Also I am attaching which Fields are relevant to which months. From F4-F12 Data is for the Month of January -23
F14-F23 is for the Month of February-23 and So on Till Jun-23
Can someone help to achieve the desired Format
Solved! Go to Solution.
- Labels:
- Dynamic Processing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@geraldo Can you check the Data Transformation workflow I have attached. I have provided the sample Input Data and the Desired Output Format.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@geraldo Please look into the screenshot attached for better understanding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@geraldo Any Approach on this ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs This is exactly the output I was looking for. Great Approach and yes it was tough actually. Thank you so much for the solution.
