First 4 characters in Column Header for Column with highest confidence?

datamodeling101

Hello,

I have 4 columns in my data flow that provide a confidence. What i'd like to do is get the column header's first four character for the highest confidence percentage and store that in a new column. How would I go about doing something like this?

Alteryx Confidence.png

In the example above for row 233, I want a new column that will be 1000, for 239 it would show 1005, etc...

Developer

Developer Tools

Accepted answers

Hi @datamodeling101

I think it does what you need.

Solution Max ID.yxmd

All comments

Hello @datamodeling101 ,

Can you please provide a couple of records as a sample data.

Hi @datamodeling101

I think it does what you need.

Solution Max ID.yxmd

datamodeling101

Thank you Emil, this was much easier than I was making it out to be. The sample tool is new to me... Since it's called a sample is there a limit on the number of records?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703