Data Removal / Cleansing

Question

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/CValueDebitCreditVBTime:10:56:18               Nominal Activity - Excluding Travel        Date From:        N/C From:   Date To:        N/C To:   Transaction From:            Transaction To:            NoTypeDateAccountRefDetailsDeptT/C   VB34354JC31/07/20191DEPRECTest Transaction 11T969.17 69.17--34356JC31/07/20192DEPRECTest Transaction 21T955 55--

Output (Hopfully):

NoTypeDateAccountRefDetailsDeptT/CValueDebitCreditVB34354JC31/07/20191DEPRECTest Transaction 11T969.17 69.17--34356JC31/07/20192DEPRECTest Transaction 21T955 55--

ed_hayter · Accepted Answer

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)