How to enter row items in a field with ";"?

Help
1

Hi,
We have an excel with customer ID’s. We want to enter all these data in a single field with “;”. Could you please help with that? (ex. Customer ID1; Customer ID2; Customer ID3; …)

Thanks,
Aysegul

1 Like
2
  1. Read the data table and loop through the data table
  2. Initialize a string variable assume stringValue
  3. Get the row value using row(“customer”).tostring
  4. Append the each value to the string variable in the step 2 as stringValue = stringValue + row(“customer”).tostring + “;”
  5. Write the stringValue to the required @aysyavuz
3

Hi
here you go a xaml
hope its resolved
kindly try this and let know for any queries or clarification
join.zip (15.1 KB)

Cheers @aysyavuz

4

It works with your code. Thank you

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.