Reclassifying rows based on multiple criteria into a new column

Question

New to ALteryx and attempting to reclassify accounts departmentally based on their account numbers. Multiple and varied account numbers within each department.

What I have;

Account #Account Description$6396.04 Activities Wages$20,0506993 Transportation Fee$20,0506210 Advertising$19,5506311 Office Supplies/Equipment$20,2026311.01 Office Equipment Contract$17,8066396.02 Maintenance Wages$2,7286537 Grounds Contract$20,0506311.04 Shred Services$2,7286321 Consulting Fee$1,3206390 Misc. Administrative Expenses-$9606391 Software Expense$2,2946396.03 Dietary Cooks Wages$20,0506933 Dietary Supplies$20,0506932 Food$19,5506396.07 Housekeeping Wages$20,2026952 Other Housekeeping-Odor Control$11,0786396.02 Maintenance Wages$2,7286519 Exterminating Payroll/Contract$1,3206538.02 Cap Expense$19,5506890 Misc. Financial Expenses$20,2026396.05 Resident Care Aides Wages$15006396.06 Licensed Practical Nurse Wages$15006396.09 RCM/NCM Wages$05122 Humana$1,5005123 UHC$1,5005127 State Community Care$7,0005120 Tenant Rent Revenue$14,616

What I need;

Account #Account Description$Department6396.04 Activities Wages$20,050Activities & Social 6993 Transportation Fee$20,050Activities & Social 6210 Advertising$19,550Admin & General6311 Office Supplies/Equipment$20,202Admin & General6311.01 Office Equipment Contract$17,806Admin & General6396.02 Maintenance Wages$2,728Maintenance 6537 Grounds Contract$20,050Maintenance 6311.04 Shred Services$2,728Maintenance 6321 Consulting Fee$1,320Admin & General6390 Misc. Administrative Expenses-$960Admin & General6391 Software Expense$2,294Admin & General6396.03 Dietary Cooks Wages$20,050Dietary 6933 Dietary Supplies$20,050Dietary 6932 Food$19,550Dietary 6396.07 Housekeeping Wages$20,202Laundry & Housekeeping 6952 Other Housekeeping-Odor Control$11,078Laundry & Housekeeping 6396.02 Maintenance Wages$2,728Maintenance 6519 Exterminating Payroll/Contract$1,320Maintenance 6538.02 Cap Expense$19,550Maintenance 6890 Misc. Financial Expenses$20,202Admin & General6396.05 Resident Care Aides Wages$1500Resident Care6396.06 Licensed Practical Nurse Wages$1500Resident Care6396.09 RCM/NCM Wages$1500Resident Care5122 Humana$1,500Revenue5123 UHC$1,500Revenue5127 State Community Care$7,000Revenue5120 Tenant Rent Revenue$14,616Revenue

I've tried the nested If then elseif formulaic approach to no avail,  Also, attempted the tile tool approach with no luck . Any help is appreciated.

smknowles · Answer

Typically through interpretation of the operating statements account descriptions and applying prior knowledge of industry norms. The objective is to consolidate the accounts into more broadly defined departments for comparison to industry metrics. Also, for concise presentation to the end user.

Qiu · Answer

@smknowles

How do you decide the Department for account#?