Hi, I have a set of data that is structured as many rows in a single column within a data table that I need to concatenate into a single row, separated by a semicolon. What is the best way to do this in UiPath. Below is an example how the data is currently structure and how I need to re-structured:
Currently structured in data table:
123
456
745
459
154
with dtOpenCases as the name of my data table and nCaseID as the name of the column I am referencing in the example above. UiPath is giving me an error under Row=String saying that it is expecting a period but when I replace the = with a period, I still receive the same error.
by the way, is it .net notation? Maybe you could point to good resource with examples, I miss a lot not having solid .net background for making complex queries like this.