I have a column ID in my data set, I need to check if the 6th digit is “6” then I need to mention the number as territory1 otherwise it’s Territory2.
E.g. 4587144 is Territory2 and 4125761 is Territory1
try this am not sure
LOAD * INLINE [
pick(Right(data, '6'), 'ter', 'ter2')
Retrieving data ...