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 |
---|---|
53 | |
27 | |
26 | |
24 | |
21 |