reorganizing data tool

I need to reorganize this report, but am not able to find a way to do so... as you can see, the report brings the name of the company in the top, the invoices bellow the name, and the name once again with the total amount at the far right. I need the name of the company in column A, the invoice/invoices number/s in column B, and transform column K in column C. Is it possible? the first file is the way I receive the report, and the second is the way I want it after the modifications...

Workflow

Output

Transformation

Optimization

Accepted answers

geraldo

@pedrorad

I put the 1 character limit to validate.
We can release to any number in any position.
Occurs if the company has a number in its name, it will be entered as an invoice.
But you already know where the filter is to improve in the future, maybe regulate expression more in the future

I am releasing the substring for any position of [Invoice] and a number

attached workflow

reorganizing 3 sampleTotal.yxmd

All comments

geraldo

@pedrorad

if you can send this print sample in excel format I will transform it quickly

in your example it was at 30 and 60
And if you have information at 90 and + 90 how do you want the result,,,
mount a test sample and how you want the result and send the file

pedrorad

Hey Geraldo,

I dont need the 30, 60, 90. All I need is the total. Find attached the excel file, the first tab is the report with no treatment, and second tab is the format I want it to be. Let me know if you have any questions. Thanks so much!

Sample.xlsx

pedrorad

Hi Geraldo, ive been trying to run the flow with other reports (utilizing the same format as the one you sent), but there is a issue with the outflow that im not able to identify. I attached the alteryx and the report excel im trying to run.

reorganizing 3 sample test.yxmd

Aged Payable Reports (7).xlsx

geraldo

@pedrorad

hi.

replace the multirow tools formula that I'm putting in the print:

Substitute for [Row-1:InvoiceKey]
and checks the result will be expected

pedrorad

Hey Geraldo, some times the invoices contain letters as well, as per the report I attached. I guess the flow does not recognize them... Is there a way to do so?

Aged Payable Reports TEST 2.xlsx

geraldo

@pedrorad

I am releasing the substring for any position of [Invoice] and a number

attached workflow

reorganizing 3 sampleTotal.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335