Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Merge Duplicate rows

qlikvw2019
7 - Meteor

Hello,

 

I have data like below.

ITEM_ID , ITEM_NAME , CATEGORY are unique , but repeated in below data , due to different qty and region

 

ITEM_IDITEM NAMECATEGORYQTYREGION
453The Harry PotterFICTION12NA
453The Harry PotterFICTION45EU
187Nimona COMIC10NA
987Animal FarmNONFICTION40NA
987Animal FarmNONFICTION56EU
987Animal FarmFICTION43NA
987Animal FarmFICTION11EU
360Planet HulkFICTION44NA
568Batman : Year oneFICTION23NA
568Batman : Year oneNONFICTION45NA

 

I am looking for below output, should display one occurrence of each row per category and split the region into 2 columns

 

ITEM_IDITEM NAMECATEGORY#NA#EU
453The Harry PotterFICTION1245
187Nimona COMIC10 
987Animal FarmNONFICTION4056
987Animal FarmFICTION4311
360Planet HulkFICTION44 
568Batman : Year oneFICTION23 
568Batman : Year oneNONFICTION45 

 

Ex. Harry potter row needs to be repeated on one time (fiction only) and the #'s needs to be split into 2 columns.

Animal Farm has 2 occurrences instead of 4, (one per category) and the # should be split into 2 columns.

 

Thankyou for your help!

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @qlikvw2019 ,

 

Attached is an example showing how to do it. For that type of manipulation, you can use a cross-tab tool.

fmvizcaino_0-1581394630346.png

 

Best,

Fernando Vizcaino

qlikvw2019
7 - Meteor

Thankyou for such a quick and accurate response!

Labels