reorganizing data tool

[pedrorad]

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...

[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!

[geraldo]

@pedrorad 

An workflow example

[pedrorad]

Perfect Geraldo! Thanks so much

[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.

[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? 

[geraldo · Accepted solution]

@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