Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Specific data to be copied to below row

mmustkee
9 - Comet
‎06-02-2021 10:00 PM

Hi Team,

 

Please refer attached. I need to select 'R' from column 'D' and wants to create a duplicate row along with all the data. Please create a blank row below wherever we have 'R' in column 'D' and paste all data from 'R' row to below blank row. do this for all wherever we have 'R' in column 'D'. For example please refer below.

Thanks for your help in advance.

 

ABCDEFGHIJKLMN 
ASSqwww121OQQQQ5678888AAA1234455Delhiana2.3466666zz 
ASSqqqqq121RQQQQ5689999BBBB233456Banglurumana3.45666666aaOriginal Row
ASSqqqqq121RQQQQ5689999BBBB233456Banglurumana3.45666666aaDuplicate Row
SDSqwww121RQQQQ45623345CCCC455678Chennaitana56.77777777qqOriginal Row
SDSqwww121RQQQQ45623345CCCC455678Chennaitana56.77777777qqDuplicate Row
CVFqqqqq23RWWW567567DDDD4556Hapursana98.4488888bbOriginal Row
CVFqqqqq23RWWW567567DDDD4556Hapursana98.4488888bbDuplicate Row
GRTqwww45OWWW568678WWW8889Noidazana44.266666cc 
HTYqqqqq56SWWW4563455WWW9888Delhibana1.23444rr 
LMNqwww76TDDD567111SSSS5677ghakana2.343333ff 
GFDqqqqq89RDDD5680TTTT1234455zhadana4.562222ggOriginal Row
GFDqqqqq89RDDD5680TTTT1234455zhadana4.562222ggDuplicate Row
Preview file
10 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor
‎06-02-2021 10:21 PM

Hi @mmustkee 

 

See attached.


Cheers,

DuplicateRows.yxmd
Reply
AngelosPachis
16 - Nebula
‎06-02-2021 10:22 PM

Hey @mmustkee ,

 

You can do that by using a filter tool to isolate the records you need and then use a generate rows tool to create the duplicate rows by setting the generation limit to 2

 

AngelosPachis_0-1622697749716.png

 

 

Hope that helps,

 

Angelos

example_v1.yxmd
Reply
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels