Creating a new column and assigning a "word1" to first 50% records and "word2" to the rest

[driz]

Hi All, 

I am attempting to create a new column (using the Formula tool) called "Owner". I have a list of data in which i need to assign the first half to Owner 1 and the second half to Owner 2. Anyone has any idea how i can do this with just Formula Tool? 

[Qiu]

@driz 
Maybe you can use Create Sample tool to split the data stream then assign "Owner" respectively.

Then union back the data streams.

[Yoshiro_Fujimori · Accepted solution]

Another solution may be to compare the record ID and the threshold calculated separately.

Here is a sample workflow. I hope this helps.

[driz]

Hi Qiu,

Thanks for the response, my version of Alteryx only has the following sample methods and i cant seem to get to your example:

"First N Rows"

"Last N Rows"

"Skip 1st N rows"

"1 of every N rows"

"1 in N chance to include each row"

"First N% of rows"

I am able to split the first 50% of rows but unable to do so for the last 50% since there isnt such an option. 

I cant send a screenshot because of IT security issues. 

[driz]

Thanks Yoshiro, this works!