Hi!
I have a current dataset, which needs to be duplicated. I need the original fields to also stay, and then in the duplicated versions I need a change in four columns by four numbers. (i need the original rows, where the number currently is zero, then the same data set with a number in three of the columns stay still 0 but in the last one go to 1, then by 5 and then 10... I also need this to be mixed around, i.e the first column is 1 the other is 0 and the third is 5... basically A LOT of duplicaitons). Is there a way to do that? I have been playing around with generate rows tool, but I can only add one at the time and if when I add it the second time, the in also duplicates it more than once. I am just confused.
Thank you!
Nat
EDIT: I apologise, I added dummy data in the excel file.
the goal is for the last four columns that start with "param" to range between -10,-5,-1,0,1,5, 10.
So i want to keep all the data with all the zeroes, but also all the data to be duplicated and have a version for each one of the numbers above.
