Pivot Table

Question

Hello Friends,

I am providing below the data and the desired output which I want. I have used Summarize tool to get the Pivot. However I am not able to get the output in below format in Alteryx. I am a very new alteryx user. Please suggest me how to get data in the below output format.

Input Data (This is a sample data, the actual data set is much bigger)

CountryCompany CodeCompany NameArgentinaAR01ELANCO S.R.L.ArgentinaARG1Country Template ARAustria AT01Elanco Austria GmbHAustraliaAU01Elanco Australasia PtyLtdAustraliaAU90Elanco Australia Holding

Output Data after using pivot table in Excel (I want to apply configuration  in alteryx which will give me the Pivot table in below format)

CountryCompany CodeCompany NameArgentinaAR01ELANCO S.R.L.AustraliaAU01Elanco Australasia PtyLtd AU90Elanco Australia HoldingAustria AT01Elanco Austria GmbH

Raj · Answer

@duttaabhishek7

this can be achieved by combination if 2 tools first a unique tool to get unique and non-repetitive "country code."
{kindly arrange the countries prior to this as it will take only first record as unique and rest as duplicate}
 then a multi row formula to have blank in place of repetitive country.

hope this helps.

usmanbashir · Answer

@duttaabhishek7 attached workflow empties out repeating countries (using multi-row formula tool). I do think you also wanted two lines for Argentina, instead of 1 in your output data example. Hope this helps.

Pivot_20240401.yxmd

jdminton · Answer

@duttaabhishek7 can you rephrase your request? What is your end goal? Creating an output that would match is not difficult, but if you are trying to summarize data to get the output, your input data does not align with a summarize. Also, the pivot table in Excel has an option to leave out repeating "Country" as shown in your output, but in working with data, you would not want to remove that while it remains in Alteryx as each data line needs that information in order to remember it. It's similar to the Excel table you're building your pivot table from.