Delete rows

Question

Hi all,

As a starting point, I have a table that must first be limited to the relevant areas. Irrelevent are information such as "who pulled the report in the system", "date" or subtotals. After the headers there is also a line I do not need.

What the file looks like:

Company

Partner

Account 1

Account 2

2023 (in USD)

0001

0100

560.000

516.140

0002

0100

4.854.752

152.422

0003

0100

1.223

4.857

report as of

Date

Time

Name

What the file should look like:

Company

Partner

Account 1

Account 2

0001

0100

560.000

516.140

0002

0100

4.854.752

152.422

0003

0100

1.223

4.857

As I am still a beginner with Alteryx I do not know what the best way would be. I am thinking of a combination of multirow formular and filter but not sure.

Can anyone help me please?

Thanks in advance!

Prometheus · Accepted Answer

My attached workflow skips the first row with a Sample tool to take out "2023 (in USD)". Then the Filter tool only allows records to pass that start with "0". If Company is not always going to start with "0", then you can filter out any records where Company is null and where REGEX_Match([Company], '^\d+').