Dynamically split data into streams by columns
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
Biswarun
8 - Asteroid
‎08-08-2022
01:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My input data header is of the form:
A | B | C | A_FLAG | B_FLAG | C_FLAG |
- There might be further pairs of column.
- A, B, C etc. will vary based on the incoming data.
- That is, the first thee column headers might be Country, City, and Village. The next three, Country_FLAG, City_FLAG, and Village_FLAG. So on.
I want my incoming data to be split into streams for each pair:
A | A_FLAG |
-----
B | B_FLAG |
-----
C | C_FLAG |
-----
So on....
Labels:
- Labels:
- Dynamic Processing
1 REPLY 1
Ladarthure
14 - Magnetar
‎08-08-2022
02:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Biswarun,
you can do this by first doing a transpose then transforming the headers you used to have into new headers easier to read and catégories. Then you can do a cross tab to have the data in the format you want.
Find attached an example workflow doing this trick, you may have to tweak it a bit if you end up having field names (other than flags) containing _