Hi, please bear with me as I am quite new to UiPath. It’s a small issue but I’ve been puzzling over it for a while.
I am trying to merge 3 datatables using “No” as the PrimaryKey. “No” is a number prefixed either by an S or T. So far I’ve managed to read them as 3 DTs, used regex to replace either S or T for DT1, and then assigned “No” (e.g. 1001, 1002) as the PrimaryKey. I can then merge the 3 DTs.
But my problem is that if I do this, in the merged DT, “No” shows up with only the numbers, without the S or T. How can I merge them so that it shows up as the desired output below instead?
|No||Data A||Data B||Data C|