topic Re: Add a New Row in Alteryx Designer Desktop Discussions

Add a New Row

ebledsoe22 — Fri, 28 Oct 2022 14:29:45 GMT

Hello. I am working on an apportionment template. I need to add an information only row into my data. What is the best way to do this? Below is a screenshot of my desired format. The row I want to add is the total row with "AL000000".

Re: Add a New Row

gautiergodard — Fri, 28 Oct 2022 14:54:19 GMT

Hey @ebledsoe22

Is something like this what you are looking for?

Re: Add a New Row

ebledsoe22 — Fri, 28 Oct 2022 15:10:50 GMT

Yes, would I need to add your complete workflow to mine or is there a specific piece that I would need to extract?

Re: Add a New Row

gautiergodard — Fri, 28 Oct 2022 15:17:29 GMT

@ebledsoe22 You can take my workflow and just switch out the text input i used, with your full data set included on your screenshot.

If you need to add totals for the rest of your columns, you'll just need to update the summarize tool as well and "sum" all the other columns included in your screenshot. Once those additional totals are calculated, you can rename those calculations directly in the summarize tool.

Hope this helps, let me know if you have any questions.

Re: Add a New Row

ebledsoe22 — Fri, 28 Oct 2022 15:21:18 GMT

I see. So there isn't a simpler "add a row function" like there is for columns?

Re: Add a New Row

gautiergodard — Fri, 28 Oct 2022 15:32:46 GMT

Hey @ebledsoe22

You could probably also do it using a combination of generate rows + mutli row formula tools.

Attaching another way to do which is more dynamic - this is what I would use.

Re: Add a New Row

ebledsoe22 — Fri, 28 Oct 2022 15:52:50 GMT

Thank you! I appreciate your time and assistance.

Re: Add a New Row

gautiergodard — Fri, 28 Oct 2022 15:55:23 GMT

@ebledsoe22 Kindly accept the post which answered your question so that others can refer more directly to the solution in the future :)

Re: Add a New Row

ebledsoe22 — Wed, 02 Nov 2022 11:38:49 GMT

Thank you for your help. I decided to add record numbers to each row and sort them in an ascending fashion to get the rows in the order that I needed them.