Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

merge multiple rows and columns

Kaish
8 - Asteroid

Hi All, can someone help me with a solution, I am able to solve for one column merge but in my case I want 2 columns and rows to be merged,

Ex- Input : this is the data which I got after using cross tab, after this I want my output. 

Internal/External         Action                 Criteria            Count

  External                      Keep                 A- Rise             96

  External                      Keep                 A- Dawn           494

  External                      Remove            A-Rise               20

  External                      Remove            A-Dawn              38

  Internal                       Keep                 A- Rise              94

  Internal                       Keep                 A- Dawn            370  

  Internal                       Remove            A- Rise             16

  Internal                       Remove            A- Dawn            37

 

Output:

Internal/External                Action                Criteria                   Count   

   

     External                         Keep                 A-Rise                        96

                                                                     A-Dawn                     494

                                           Remove             A-Rise                        20

                                                                     A-Dawn                       38

    Internal                            Keep                 A-Rise                        94

                                                                      A- Dawn                    370

                                            Remove             A-Rise                       16

                                                                       A- Dawn                    37

 

Can anyone help me with this output?

                                            

5 REPLIES 5
DataNath
17 - Castor
17 - Castor

Hey @Kaish, are you talking about when Rendering an output, and looking for something like this?

 

RenderMerge.png

OllieClarke
15 - Aurora
15 - Aurora

Hey @Kaish if you want your data to look like this (rather than what @DataNath  has suggested) then I think this works
image.png

Hope that helps,

 

Ollie

Kaish
8 - Asteroid

Hi @DataNath , removing the headers will lead to my output, could you please share the flow with me ?

 

DataNath
17 - Castor
17 - Castor

Sure @Kaish - here you go.

 

if you want to re-enable headers, just use this option:

 

RenderMergeHeaders.png

 

For reference, this method works by constructing tables inside tables, which are grouped by the level above and therefore appearing as 'merged' column values.

Kaish
8 - Asteroid

Hi @DataNath  thank you for your support I was able to find out the solution, @OllieClarke thanks for the reply and solution but when I was working with my data it was having some loopholes due to null data values, anyways thank you for your support. 

Labels
Top Solution Authors