We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

How to duplicate specific rows within a table?

Serena3
6 - Meteoroid

Hello,

 

I have a table in alteryx which looks like so:

 

CountryTargetCategory
America and Canada704
China and Taiwan504
Australia and New Zealand204
France and Germany354


I want to concatenate the Country field and create new rows so that the table now looks like below:

Note that the values in Target and Category will remain the same.

 

CountryTargetCategory
America704
Canada704
China504
Taiwan504
Australia204
New Zealand204
France354
Germany354

 

Any idea how I can do it? It seems so simple but I can't figure it out.

 

Thanks

2 REPLIES 2
benakesh
12 - Quasar

Hi @Serena3 ,

Formula  and  'text to cols'  tools can get expected results . 

Serena3
6 - Meteoroid

I didn't know you could 'split to rows' as I've only ever used 'split to columns' haha I feel silly... thanks!

Labels