community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Sum Up field

Asteroid

MBRHISTR1.png

Hello,

I need help to create a work flow with attached scenario.

Alteryx Certified Partner
Alteryx Certified Partner

I  think we need to understand exactly what your ingoing data looks like; could you please share an excel file with a sample input; with any compleixities there may be (i.e. for more than one record).

 

Ben

Asteroid

 

Hello @BenMoss ,

 

Thanks  for your response. I have 14 millions rows of data coming from different inputs. So is kind of hard to put in a single example. All  I want is to break down the changes on [ENERGY] column and [SLCHG] column of TABLE # 1 to look like  

TABLE # 2

2019-02-13_1240.png

 

 

 

 

 

 

EXPECTED RESULTS TABLE # 2

 

2019-02-13_1244.png

 

 

 

 

 

 

 

 

 

The scenario is: IF [TYPSRV] = "E" THEN the [CHG AMT] is accumulated in [ENERGY]

                           IF [TYPSRV] = "L" THEN the [CHG AMT] is accumulated in [SLCHG].

 

REFFER TABLE # 2 FOR EXPECTED RESULTS.

 

Any help I will appreciate.

 

Thanks

Evans

                        

 

Alteryx Certified Partner
Alteryx Certified Partner

@EvansM 

 

How about this:

 

Since they appear to be mutually exclusive, you could just add them.

[Energy] + [SLCHG]

Cheers,


Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid

@MarqueeCrew  As you see TABLE # 1 [ENERGY]  row #1  the total is 329.77. I want to break down the cost by [TYPSRV] Then add total at the end. Refer table # 2 for expected results.

 

Thanks

 

Alteryx Certified Partner
Alteryx Certified Partner

@EvansM ,

 

It would be great to see a set of data (via a text input tool) that has only a focused set of data elements to work from.  Then the expected or desired results.  Looking at the pictures, I'm guessing at the source data.  If you could make this look like a "Weekly Challenge", I'm certain that many folks could contribute help.

 

Cheers,


Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid
Highlighted
Asteroid
Alteryx Certified Partner
Alteryx Certified Partner

@EvansM ,

 

Here's my solve:

 

capture.jpg

 

I took the RAW data and transposed it into a single vertical set of data keyed by Route, Loc, Res, HDate, TypSRV.

I calculated a "Header" with your L or not-L logic.  Then I realized that I had to create a TAX header too.  Then I converted it back horizontally using a Cross Tab tool (aggregating with a SUM).

 

I think that I match your desired output (different sort order).

 

Cheers,


Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid

@MarqueeCrew  Thanks a lot

Labels