Two.5 questions being asked here. The basis is an existing data table that is destined to be bulk loaded into queue up in Orchestrator. The questions are:
I have a column where the values are “88888888-###”. Basically 8 digits followed by “-” and then some other number of digits. Without a For Each, how can I take that column’s value and remove the “-” and all following text from the string and push that back into the same column value.
2.5) Or … possibly take the value without the “-###” portion of the string and push that into a new column in the datatable.
Add a Reference Column - My question isn’t how to add the column itself. Plenty of examples on that. My question is how to add it and automagically fill in the reference values. Say using values generated using Guid.NewGuid().toString or something similar … without using a For Each loop. Not sure I’m going to keep the Reference column and the Unique Ref setting on the queue. Stilling working out the queue logic for the queue drainer flow.