Creating data table from statement

[tiverson]

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

[ArtApa · Accepted solution]

Hi @tiverson - Here is a possible solution: