community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

How to Populate Gender field with Generate Rows tool

Alteryx Partner

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.

Alteryx Certified Partner
Alteryx Certified Partner

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!

Alteryx Certified Partner

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

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Highlighted
Alteryx Partner

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

Alteryx Certified Partner
Alteryx Certified Partner

@anishbhola,

 

Please try the following:

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

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx Partner

@

 

Thanks Marquee,

Pretty Concise and fast approach.

Thanks all for support.

Labels