Delete/remove specific rows
- 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
How do I delete all the rows that contain:
For example: a column with "text here..." or Null under column C?
Thank you!
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@OOIWJ: something like this should help you out. Change out the "Test" field for the field you want to filter.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@OOIWJ You can use the Filter tool to remove records that don't meet the criteria you specify.
 
 
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have unique things to delete, but the current method suggested would mean I need to filter many times?
Kindly see image for my example of what I want to remove. Context: General ledger
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@OOIWJ; those were the requirements in the OP.
I would suggest you dynamically remove these records you don't want through the usage of an analytical app (see attached). It'll ultimately mitigate the number of filters you are needing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@OOIWJ You can configure your Input Data tool to skip any number of lines by changing the number on "Start Data Import on Line" in the tool configuration. This is especially helpful when inputting a report with headers. I used the Data Cleansing tool after that to remove null columns, then used the Dynamic Rename tool to rename all the fields with the first row of data. I finished the workflow off by renaming "VOUCHER" to "VOUCHER NUMBER".
 
 
 
 
 
