Hello,
Here is what I want to do:
I am having an excel sheet with a column named Gender, this column is completely empty and basically the whole sheet is.
I want to fill 1790 values in that column consisting of 1012 Female values and 778 Male values and I have been using Generate Rows tool for this, but the problem is I am only able to generate rows only for one particular case: either 1012 Females or 778 Males.
I want to input whole of the data simultaneously and fill that Gender column.
Kindly guide me on this.
Thanks.
Solved! Go to Solution.
Could you not use two generate rows, one which generates 1012 rows with the value "Female" and a second which generates 778 rows with the value "Male" you can then union these streams together and you will have what you are after.
I may be misinterpreting the desired result though!
As much as it pains me to say, I think @BenMoss is correct
Part time Tableau, Part Time Alteryx. Full Time Awesome
Thanks @BenMoss
It helped, what I was doing previously was using only one Generate Rows Tool which was causing a bit trouble for me.
Please try the following:
IIF([RowID]<1791,"F","M")
Cheers,
Mark