This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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".