We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Change Table output

Uzi
8 - Asteroid

Hey guys, little hard task 😄

 

I have to change the "design" of a table which is realy huge. Is it possible to do that by alteryx? Example given, left table is the input table and right how it should the output looks like. 

Uzi_0-1607348057998.png

 

7 REPLIES 7
Emil_Kos
17 - Castor
17 - Castor

Hi @Uzi,

 

Maybe split the data into two data sets and afterwards join the data by Column 2. 

 

I used part of your data to create a workflow for you. The only thing that I done is spliting the data to two data sets. and then join them afterwards. 

 

it is really simple and it should work for you. 

 

 
 

 

 

Emil_Kos
17 - Castor
17 - Castor

Hi @Uzi,

 

I have amended my previous message + added a workflow to it. 

Creating a new post to make sure that you will not miss it. 

 

Good luck!

Uzi
8 - Asteroid

thanks a lot. I will try to implement it to my workflow and will inform you it is worked or not. 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@Uzi ,

 

Let's keep it simple:

 

Summarize for MAX # value

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
grazitti_sapna
17 - Castor

Hi @Uzi,

 

Here is my take on this issue.

 

grazitti_sapna_0-1607409054826.png

I hope it helps.

 

 

Sapna Gupta
Uzi
8 - Asteroid

thanks to @Emil_Kos and @grazitti_sapna 

worked perfect

Uzi
8 - Asteroid

Hi Together, I detected a weird issue... Im doing the same thing as you guys and its duplicating the records. Instead of 250 I got 1000 records? Any idea? 

Unfortunately I cant upload my data, high confident 

Labels