How to Populate Gender field with Generate Rows tool

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.

Preparation

Accepted answers

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!

Thanks @BenMoss

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

All comments

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. Screenshot (162).png

Please try the following:

Generate 1790 rows
Use a formula tool to define gender
```
IIF([RowID]<1791,"F","M")
```

Cheers,

Mark

Thanks Marquee,

Pretty Concise and fast approach.

Thanks all for support.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703