SOLVED
Fields with no data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Analytics_Pooja
8 - Asteroid
‎03-21-2022
04:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a dataset with a field called BM. There could be n number of Business Managers for each Identifier at given point of time. I am transposing the data to get different fields as BM1, BM2, BM3 and so on. I want fields upto BM5 even if BM4 and BM5 doesn't exists. For example
Identifier | BM | ||||
1 | Steve | ||||
1 | Neha | ||||
1 | Richard | ||||
2 | Usha | ||||
2 | Mandy | ||||
2 | Nancy | ||||
Output | |||||
Identifier | BM1 | BM2 | BM3 | BM4 | BM5 |
1 | Steve | Neha | Richard | ||
2 | Usha | Mandy | Nancy |
I want BM4 and BM5 as blank columns even if there is no data.
Any kind of help would be appreciated.
Best
Pooja
Solved! Go to Solution.
Labels:
- Labels:
- Dynamic Processing
- Workflow
5 REPLIES 5
gabrielvilella
14 - Magnetar
‎03-21-2022
04:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
21 - Polaris
‎03-21-2022
06:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Analytics_Pooja
here is my try.
‎03-21-2022
08:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@gabrielvilella transposing data is not a problem. Problem is to create BM4 and BM4 that doesn't exist in the current data but likely to get populated in next data.
gabrielvilella
14 - Magnetar
‎03-21-2022
09:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎03-22-2022
12:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/72080B1993C0EC7A53569ADF25905C2F/responsive_peak/images/icon_anonymous_message.png)