SOLVED
[HELP] How to delete unnecessary rows which come before specific keyword
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
msyosd
7 - Meteor
‎05-24-2022
06:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, Alteryx experts,
Could you please share your brilliant idea to delete unnecessary rows and keep necessary rows by keyword in one of the columns?
In the case of the attached sample financial statements, I want to delete the unnecessary BS part, which comes before and "Total Liabilities and Capital."
Basically, I only need the PL part in the sample file.
Thank you so much for your attention and participation.
Solved! Go to Solution.
Labels:
- Labels:
- Help
- Tips and Tricks
3 REPLIES 3
17 - Castor
‎05-24-2022
10:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @msyosd, I believe the following workflow ought to do the trick. If you run into any issues then let me know! The first 2 tools are just for general clean up of the input when bringing it into Alteryx.
binuacs
21 - Polaris
‎05-25-2022
02:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-26-2022
10:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
