topic Re: Multiple rows and columns to single row in Alteryx Designer Desktop Discussions

Multiple rows and columns to single row

kcvictor — Thu, 15 Aug 2019 13:10:58 GMT

Hello. I've searched the community site, but have not quite found the answer I'm seeking. I have multiple rows and columns and want to transpose it into one continuous row. Please see attached for details. I want the rows with year 20 and year 30 appended to the first row along with headers incremented by 1. The number of rows could vary. I appreciate your help and thanks in advance. Victor

Re: Multiple rows and columns to single row

Kohlmeyl — Thu, 15 Aug 2019 13:45:10 GMT

Hello,

You can use a combination of the transpose and crosstab functions to accomplish this goal. Please see the attached workflow as an example.

I hope this helps!

Re: Multiple rows and columns to single row

kcvictor — Thu, 15 Aug 2019 13:56:10 GMT

Thank you Kohlmeyl for your quick response and solution.

Re: Multiple rows and columns to single row

GiuseppeC — Thu, 15 Aug 2019 14:05:14 GMT

Hi @kcvictor

a similar approach to @Kohlmeyl's (who beat me on time!) that allows you to keep the original column order:

Hope this helps!

Giuseppe

Re: Multiple rows and columns to single row

ChrisTX — Thu, 15 Aug 2019 14:36:21 GMT

Here's one more option to ensure fields remain in the same order: the CReW macro for Block All Records

http://www.chaosreignswithin.com/2019/01/block-all-records.html

You have an input dataset and want to make sure that the output of your process (e.g. macro) contains all of the fields in the same order as the original file. You could use the Block All Records macro and stream that into a UNION tool. Then set the UNION to read #1 first. It is then up to you whether you will auto-configure by Name or manually configure the data. The bottom line is that the incoming data fields are in the same order on output.

Re: Multiple rows and columns to single row

kcvictor — Thu, 15 Aug 2019 15:26:40 GMT

Thank you GiuseppeC. I was wondering how to change the order and this helps. Victor