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!
Solved! Go to 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+').
Thanks a lot!
User | Count |
---|---|
59 | |
26 | |
24 | |
22 | |
21 |