How do I use the generate row data to create one additional row of data when certain conditions are

I would like to create one additonal row of the same data if a certain string is in two fields of my data in one row. How do I acccomplish this?

For example, if the one of the fields reads "DIRCT', I would like for Alteryx and the generate row data tool to create one additional row of data where all the data remains the same except for one data field. Is there anyone that can help me get off to the right start with this? Thanks!

Preparation

Accepted answers

kane_glendenning

Hi Benjamin,

Easy way, simply filter for "DIRCT" and then change the data that needs changing. Union back together all the original data plus the new data. To use the generate rows tool, you would have to have a 2 stage process whereby you assign a RecordID and multiply it by 2, then use that in your condition as well as Field1="DIRCT".

Kane

All comments

kane_glendenning

Kane

viswamtulasi

I would like to create no. of additional rows based on Field “Rows” value of the same data –

For example of the Input Data –

Name	Location	Rows
Sam	NY	2
David	NJ	1
Joe	HI	4

The out result should be –

Name	Location
Sam	NY
Sam	NY
David	NJ
Joe	HI
Joe	HI
Joe	HI
Joe	HI

Is there anyone that can help me get off to the right start with this? Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703