Hi!
So, I have some information on my sheet such as the name of the company. I want to combine them (the same company) into one and add them together.
I want to add the columns of value and SHRS or PRNT AMT seperately. I'm wondering if anyone can guide me on what to do with this.
Also, when I select the data, I changed the Value(x1000) and SHRS or PRN AMT to Double. HOWEVER, the numbers become smaller. For example, before I changed them, they were like 1,000,000 now like 100? I'm not sure if it's a bug or something.
Thank you very much
Solved! Go to Solution.
Hi @rively90
You'll want to use the summarize tool. Group by the issue and SUM the amount columns (assuming the data type is numeric). For your second thing about the number changing - please provide sample input/workflow so we can review your configurations.
https://help.alteryx.com/20214/designer/summarize-tool
Hi @rively90
You'll need to export the workflow so the input files are maintained (assuming no confidential data). Go to Options>Export Workflow.
Hi,
regarding the number changing - please remove the commas (thousands separators) and it should work fine:
thank you so much. it works
Glad to hear that!
Hi @rively90
A few pointers/suggestions here:
Please reach out if you have any questions. Have a great weekend!
thank you for replying!
I'm new in Alteryx. My tutor told me to make a separate tool container instead of the dynamic input. Our end goal is to https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Converting-Basic-Table-to-Desired-Tabl... and probably make interactive graphs. I'm not sure how to make interactive graphs like Tableau in Alteryx.
I'm also new to Alteryx. This is my first week using it. Thanks for your feedback! It will save time in the future!