Workflow
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
dvernon
6 - Meteoroid
‎07-29-2021
11:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How to remove subtotals and blank lines from my data?
Labels:
- Labels:
- Dynamic Processing
7 REPLIES 7
atcodedog05
22 - Nova
‎07-29-2021
11:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎07-29-2021
11:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Frist Step
I have a file that have blank rows and subtotals. I would like to remove them. I tried using data cleansing but it does not seem to be working.
Please see screen shot below.
Should I use the data cleansing tool first to remove blank rows and subtotals?
atcodedog05
22 - Nova
‎07-29-2021
11:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JagdeeshN
12 - Quasar
‎07-29-2021
11:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @dvernon ,
Similar to what @atcodedog05 mentioned in his reply, please find attached a sample workflow to do this.
Note:- The workflow uses sample data.
Hope this helps.
Best,
Jagdeesh
‎07-29-2021
11:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My apologies, please see attachment.
JagdeeshN
12 - Quasar
‎07-29-2021
11:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
atcodedog05
22 - Nova
‎07-29-2021
11:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator