Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to Populate Gender field with Generate Rows tool

anishbhola
7 - Meteor

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.

5 REPLIES 5
BenMoss
ACE Emeritus
ACE Emeritus

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
15 - Aurora

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

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

anishbhola
7 - Meteor

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

MarqueeCrew
20 - Arcturus
20 - Arcturus

@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 restart. Order shall return.
Please Subscribe to my youTube channel.
anishbhola
7 - Meteor

@

 

Thanks Marquee,

Pretty Concise and fast approach.

Thanks all for support.

Labels