Forum - Deutsch
Suchen Sie nach Antworten, stellen Sie Fragen und teilen Sie Ihr Alteryx-Wissen.
Hi @Torben_Wiesbach,
welcome to the Alteryx Community and especially to the German Forum! Feel free to speak up in German next time. As the post was asked in English, I'll continue in English.
As often, it's definitely possible in Alteryx and doesn't need much tools to do so. I'll show you how it could be done.
The workflow looks like this:
And the result matches yours if I see it correctly:
Let's take a look how we achieved this:
0. I expect that your data comes in with no header, this makes it easier to handle it. For your real file, just deselect that the first Row contains field names in the option.
1. Separate the Account Number from the Word "Account". This can be done with a Text-To-Columns tool that splits by whitespace (\s):
The result afterwards looks like this:
2. In the next step we want to fill up the account-rows with a Multi-Row-Formula. We can simply say "If the current row is null, than take the previous row, if it's already filled, leave it as it is"
The result looks a lot better!
3. We move on with the Acc. Description column, therefore we could use another Multi-Row-Formula:
This time it looks a bit more tricky, but it's actually easier. We use the Group By option with our newly created field Account. Therefore we can say, if the previous description is null - this happens only at the first entry of every group, we take the value from the Field2 column. If the previous value isn't null, we can just take the previous one.
The result looks like this and we are almost done:
4. Time for some basic renaming and re-ordering. (Select Tool)
5. In the last step we remove all Rows with a Filter Tool that contain the Word "Account" or "Date" in the 'Date' Column.
An easy way to achieve this is using the IN-Funtion that basically checks if a value is in a list. In our case we add 'NOT' in front to remove all lines that contain one of these words.
That's it 🙂
I'll attach the workflow as a reference for you. Let me know if this helped and yet again, welcome to the forum!
Best
Alex
