I have a bank statement that I can read into Alteryx, however they display the daily "Net Amount" in a different format than the rest of the statement.
How can I assign the "Net Amount" to the account listed in the detail above, by date, using the amount listed in column G? I need to use this amount so I can check the daily activity. This is the part that I having a difficult time with.
Statement example
Desired output
Solved! Go to Solution.
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |