Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Coherently Organizing Columns (Charges on an Invoice Report)

a718
6 - Meteoroid

I have an invoicing report that breaks all charges down just like this:

 

Original ReportOriginal Report

 

My desired output (open to suggestions if there's something more intelligent) is one where I can see the transaction number, its reference number, and all the types of charges associated with it, like so:

Desired OutputDesired Output

 

Can someone please assist?

4 REPLIES 4
ImadZidan
12 - Quasar

Hello @a718 ,

 

Do you have a dataset we can work with?

 

Please attach and we will do it.

a718
6 - Meteoroid

Hi ImadZidan,

Absolutely, please see attached. For confidentiality purposes, I changed the transaction and reference numbers, as well as added an arbitrary value to the cost numbers. Should still be solveable, all the same. In this instance, there are no ExtraAmount4's, but in the future there might be! 

a718
6 - Meteoroid

@ImadZidan (sorry, forgot to tag you)

ImadZidan
12 - Quasar

Hello @a718 ,

 

Please have a look at the attached.

 

I hope you find it helpful.

 

I see in the final output the order of the charge type may need to be looked. May be not. the choice is yours.

 

Any issues, shout back.

Labels