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

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

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