@ccg1706 Yes, your approach is correct.
@fernandac322631
After the load file activity have an enrichment that does the transformation on the data to split the number using the substring function and use that in the update activity to update the table.
Here is the sample expression if the incoming n...