Split column and replace with associated fields and concatenate
I have a field with information separated by '/' and this filed include Null values also i.e,"Route Segment" in the below example. I need to create one more filed "Route Sales" based on filed "Route Segment".
"RouteSales" filed logic should be based on SalesRepID. Routesegment is based on Segments and it is a concatenation of segments "Route Sales" is a concatenation of salesRepID but it will have some null values as same as in 'RouteSegment'