Change Table output

[Uzi]

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. 

[Emil_Kos · Accepted solution]

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]

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]

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

[MarqueeCrew]

@Uzi ,

Let's keep it simple:

Summarize for MAX # value

Cheers,

Mark

[grazitti_sapna · Accepted solution]

Hi @Uzi,

Here is my take on this issue.

I hope it helps.

[Uzi]

thanks to @Emil_Kos and @grazitti_sapna 

worked perfect

[Uzi]

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