How to Populate Gender field with Generate Rows tool

[anishbhola]

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.

[BenMoss · Accepted 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!

[LordNeilLord]

As much as it pains me to say, I think @BenMoss is correct

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[anishbhola · Accepted solution]

Thanks @BenMoss 

It helped, what I was doing previously was using only one Generate Rows Tool which was causing a bit trouble for me.

[MarqueeCrew]

@anishbhola,

Please try the following:

1. Generate 1790 rows
2. Use a formula tool to define gender
   

   IIF([RowID]<1791,"F","M")

Cheers,

Mark

[anishbhola]

@MarqueeCrew

Thanks Marquee,

Pretty Concise and fast approach.

Thanks all for support.