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?

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

[ImadZidan]

Hello @datamodeling101 ,

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

[Emil_Kos · Accepted solution]

Hi @datamodeling101 

I think it does what you need. 

[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?