topic Re: How to place multiple columns under one column in Alteryx Designer Desktop Discussions

How to place multiple columns under one column

danielsnook — Fri, 16 Nov 2018 15:13:27 GMT

Hi all, does anyone know how to go about placing a specific column under another column? For example placing column D under column B while still keeping the first two columns consistent.

Before

Number	Name	A	B
1	John	1	48
9	Barb	43	27
1000	Willy	60	42
1001	Steve	98	94

After

Number	Name	A
1	John	1
2	Barb	43
3	Willy	60
4	Steve	98
Number	Name	B
1	John	48
2	Barb	27
3	Willy	42
4	Steve	94

Thanks

Re: How to place multiple columns under one column

kat — Fri, 16 Nov 2018 15:35:41 GMT

Hi @danielsnook

Have a play with the transpose tool. I think you'll struggle with those repeating field names, but it might be what you need.

Cheers

Kat

Re: How to place multiple columns under one column

ddiesel — Mon, 19 Nov 2018 18:27:23 GMT

Hi @danielsnook!

Try this setup and see if it works for you. In your Input Data tool, make sure to check the box in setting #6 for "First Row Contains Data" as the field names are treated as records to match your desired output.

Re: How to place multiple columns under one column

ThizViz — Tue, 20 Nov 2018 00:26:00 GMT

I'll toss out another possibility, but it will depend on how many columns you have.

First, in your input tool, check the "first row contains data" box.

Use a select tool to pick only Number, Name and A, but change the name of A from F3 to Value

Copy and paste that select tool (connect to your input) and change your selection to Number, Name and B. Again, rename column "B" (F4 or whatever) to Value.

Continue until you have all your columns, then union all.

Now your data is arranged as you've described and you can rename your column headers any way you want.

It appears that your data is structured according to some pre-defined report, but just in case you ever want to use it in Tableau, for instance, there's a better way. I'll whip up an example for you.

Re: How to place multiple columns under one column

ThizViz — Tue, 20 Nov 2018 06:02:54 GMT

Here's a little bit different way to prepare the data in case you need to present it in another tool.

Re: How to place multiple columns under one column

ThizViz — Tue, 20 Nov 2018 06:03:02 GMT

Here's a little bit different way to prepare the data in case you need to present it in another tool.

Re: How to place multiple columns under one column

danielsnook — Mon, 26 Nov 2018 21:38:35 GMT

Thanks this worked out great! The transpose tool was giving me a little bit of trouble before, much appreciated.

Re: How to place multiple columns under one column

ddiesel — Wed, 28 Nov 2018 00:30:06 GMT

Glad it worked out for you!