Alteryx Formula to count the field

Hi Team,

In the same column, i have two different sets of data,

Data as follows , 12 digit Alphanumeric and few of them 9 characters like mentioned below , i want to make new column by using formula that if field having 12 characters then RED , If field contain 9 character then Green.

Please help me out in this regards! - Thanks in advance.

Input
Column
040114AV2
36209CVG8
US36224NWQ23
CA078149DW82

Required Output

040114AV2	GREEN
36209CVG8	GREEN
US36224NWQ23	RED
CA078149DW82	RED

Common Use Cases

Accepted answers

All comments

atcodedog05

Hi @Jaganmohan

You can use formula like below

IF Length([Field1])=9 THEN "Green" ELSE "Red" ENDIF

Workflow:

Hope this helps : )

Green.yxmd

mceleavey

Hi @Jaganmohan ,

nice and simple. Just use a formula tool as follows:

if length([Input])=12 then "RED" else "GREEN" endif

Workflow attached,

I hope this helps.

mceleavey solution.yxmd

Jonathan-Sherman

Hi @Jaganmohan.,

This could be achieved with the use of two column rules in a table tool:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

20211007 - TableRules.yxmd

Jonathan-Sherman

Looks like I got the wrong end of the stick on this one! I went a little overboard 😂 Nice to show these things are possible I suppose!

atcodedog05

@Jonathan-Sherman wrote:
Nice to show these things are possible I suppose!

I wouldn't disagree on that 😅

Jaganmohan

Thanks for the Quick response .. but in the same column i have blanks as well.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177