Data Removal / Cleansing
- 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 hope everyone is well I have some data like below that I received (anonymised of course) and what I'm trying to is remove the first 7 rows from this file as a system generated them and they are not important in my case so the output i'm hoping to achieve is the second table.
I'm not 100% sure if Alteryx can do this but it would definitely save me a tonne of time as I get a lot of files like this recently.
Huge Thanks in advance
Input
No | Type | Date | Account | Ref | Details | Dept | T/C | Value | Debit | Credit | V | B |
Time: | 10:56:18 | |||||||||||
Nominal Activity - Excluding Travel | ||||||||||||
Date From: | N/C From: | |||||||||||
Date To: | N/C To: | |||||||||||
Transaction From: | ||||||||||||
Transaction To: | ||||||||||||
No | Type | Date | Account | Ref | Details | Dept | T/C | V | B | |||
34354 | JC | 31/07/2019 | 1 | DEPREC | Test Transaction 1 | 1 | T9 | 69.17 | 69.17 | - | - | |
34356 | JC | 31/07/2019 | 2 | DEPREC | Test Transaction 2 | 1 | T9 | 55 | 55 | - | - |
Output (Hopfully):
No | Type | Date | Account | Ref | Details | Dept | T/C | Value | Debit | Credit | V | B |
34354 | JC | 31/07/2019 | 1 | DEPREC | Test Transaction 1 | 1 | T9 | 69.17 | 69.17 | - | - | |
34356 | JC | 31/07/2019 | 2 | DEPREC | Test Transaction 2 | 1 | T9 | 55 | 55 | - | - |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use a sample tool with skip n rows setting and input 7 to skip the first 7 rows
You might then want to use a dynamic rename with the setting take column headers from first row of data. TO get the correct column headers. (although it seems the headers stay the same so might not be necessary)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ed_hayter Many thanks good sir that worked like a charm