How to Sum a column values

[Johnson.Joseph]

Hi,

I'm working on a huge data file and now I need to aggregate the total of a given column. Using shape, I get the Group by total.

I have researched on this topic and saw Akshay's posting for similar question

https://community.datarobot.com/t5/data-prep-q-a/how-to-actually-sum/m-p/6632#M139

I'm stuck at  Step 4: Perform a lookup to the "Look up View" , I don't see connection options in my PAXATA instance.

Help is appreciated to resolve this issue.

Regards,

Johnson

[shyam]

Hello @Johnson.Joseph ,

You could perform a lookup by using the "paper clip" icon.

This will ask you to select a Dataset to lookup from the Data Library. Here is a step-by-step guide on how to perform a lookup. 

Is this what you were looking for? If not, please respond with the screenshot so that we can understand where you are facing the trouble. 

Thanks!

[Johnson.Joseph]

Thank you Shyam for the reply. I do see paperclip option. Based on the solution Akshay provided, we need to perform a vloopup using the same data set. I don't see an option to use the same data set.

I'm looking for a solution to calculate Sum of a column using PAXATA.

[calamari]

Hi @Johnson.Joseph ,

What you're trying to do can be done the way you're trying to, but I think the function you're looking for is Window -> Aggregate option. It's a much easier way to do what i think you're trying to do.

Screenshot of the tool here->