Delete rows

[Jockel]

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)	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 solution]

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+').

 

[Jockel]

Thanks a lot!