Data Removal / Cleansing

[Deano478]

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

-

-

[ed_hayter · Accepted solution]

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)

[Deano478]

@ed_hayter Many thanks good sir that worked like a charm