Creating new column with values based on previous column values

So I'm trying to get around the basic sort tool Alteryx provides, I need rows to come out in specific order. The three types I will have is

Freight

Non-Freight

Blank ( previous tool I'm using creates totals for all values in a row, this field is blank as this is not a numeric column).

In a perfect world, I would have all the 'Freight' listed first, then 'Non Freight' then the 'Totals' row ( which is blank for this column ).

So my idea is to create a new column if Freight, then equals 1, Non Freight equals 2, blank equals 3, then sort down the line... I'm having problems getting this formula to work to create a new column.

Side note, if possible...would be even better if I can insert a blank row between these values would be even better!!!

Appreciate any help.

Desired Result

'New column'

Freight Records

(Blank row)

Non-Freight Records

(Blank row)

Totals

Developer

Developer Tools

Tips and Tricks

Accepted answers

fmvizcaino

Hi @dberroth ,

Attached is an example showing how to accomplish that.

Let me know if this works for you.

BEst,

Fernando Vizcaino

2020-01-27 Creating new column with values based on previous column values.yxmd

All comments

carlosteixeira

Hi @dberroth Can you try use this workflow to help you.

Take a look

best regards

Creating new column with values based on previous column values.yxmd

fmvizcaino

Hi @dberroth ,

Attached is an example showing how to accomplish that.

Let me know if this works for you.

BEst,

Fernando Vizcaino

2020-01-27 Creating new column with values based on previous column values.yxmd

dberroth

Thanks for the info both, I feel like this one has got me on the right track, but unfortunately the rows are being doubled up now and my subtotals at the bottom of the page are now missing. Any ideas on why that would be?

fmvizcaino

Hi @dberroth ,

Would you be able to share the part of the workflow where the problem is happening? If not, it could be a set of screenshots showing the duplication at least.

Best,

Fernando Vizcaino

dberroth

Hey Fernando - I was able to manipulate the if statements that you provided without the others and was able to make that work. I Appreciate your help on that. It got me to where I need to be! Last Question...

If you were wanting to enter blank rows between specific data in an excel sheet, do you have any recommendations on where to look for that?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703