Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Removal / Cleansing

Deano478
12 - Quasar

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

 

NoTypeDateAccountRefDetailsDeptT/CValueDebitCreditVB
Time:10:56:18           
    Nominal Activity - Excluding Travel        
Date From:        N/C From:   
Date To:        N/C To:   
Transaction From:            
Transaction To:            
NoTypeDateAccountRefDetailsDeptT/C   VB
34354JC31/07/20191DEPRECTest Transaction 11T969.17 69.17--
34356JC31/07/20192DEPRECTest Transaction 21T955 55--

 

Output (Hopfully):

 

NoTypeDateAccountRefDetailsDeptT/CValueDebitCreditVB
34354JC31/07/20191DEPRECTest Transaction 11T969.17 69.17--
34356JC31/07/20192DEPRECTest Transaction 21T955 55--
2 REPLIES 2
ed_hayter
12 - Quasar

You can use a sample tool with skip n rows setting and input 7 to skip the first 7 rows

 

Sample Tool Setup.png

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)

Deano478
12 - Quasar

@ed_hayter Many thanks good sir that worked like a charm

Labels