Creating a new category field using existing fields within the data set
Hi, I would like to create a new field to categorize our different insurance payers into a few main buckets. The logic involves using three exisiting fields to determine which payer bucket each row (insurance claim) should be called. Is it best to do this as magic transform or do in a beast mode? Currently I am using a…