SPLIT DATA USING A SPECIFIC COLUMN AND ADD COLUMN NAMES
- 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 All,
I have a situation where in I have to group data by country and after each country is over, a separate header has to be given when a new country name begins.
for eg :
ID | NAME | COUNTRY |
12 | AB | AUS |
35 | CD | IND |
64 | LE | AUS |
78 | OI | IND |
95 | FG | SUI |
21 | LF | SUI |
65 | PO | UK |
17 | LQ | UK |
This data has to look like :
ID | NAME | COUNTRY |
12 | AB | AUS |
64 | LE | AUS |
ID | NAME | COUNTRY |
35 | CD | IND |
78 | OI | IND |
ID | NAME | COUNTRY |
95 | FG | SUI |
21 | LF | SUI |
ID | NAME | COUNTRY |
65 | PO | UK |
17 | LQ | UK |
Hope its clear.
Thanks in advance
Solved! Go to Solution.
- Labels:
- Data Investigation
- Optimization
- Workflow
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Shahas
Step 7:
IF [RowCount]=2
THEN [Field1]
ELSE [Source_Field1]
ENDIF
Step 8:
Step 9:
Step 10:
Many thanks
Shanker V
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ShankerV thanks for the effort put in to post everything.
A small doubt.. At step 7, formula's are being applied to source field. In the example I provided there are only 3 source fields. But in my actual data, there a lot more. So do I have to apply formula to every columns?
Thanks & Regards
Shahas Ahamed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Thank u for the response.
But when run the flow, I'm getting a lot of duplicates.
In my data, there are 39 countries in total. In the macro section, we are giving 1 country name right in filter ? and what will we do for the false part?
Thanks & Regards
Shahas Ahamed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Shahas
Yes, as per the sample provided I have applied the formula to all 3 fields.
If in the original input, if you have more columns, then the formula should be applied to all the columns.
Many thanks
Shanker V
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/2A479D0ADEFDAA8078B5B9F489A80DDD/responsive_peak/images/icon_anonymous_message.png)