Make from a string datatable row's

Hey everyone,

I have a question. I have a String “2;3;4;5;6”. Now i want to make a datatable with 2 in row 1, 3 in row 2, 4 in row 3 etc…

So i want this, Datatable:

NR
2
3
4
5
6

Can anyone explain or show me how i can build this.

Thank you

Hi @Stefan1234 ,

Follow below steps:

1- split text with semi colon and assign it it to array of string.
2 - Use bulid data table activity to create new column as “NR”
2 - use foreach loop and iterate each array item.
3 - In body of loop use Add data row option and pass value of item.

Thanks.

Hi @Stefan1234

Welcome to community.

Please refer the xaml below.

Main.xaml (18.4 KB)

Regards

Hi @Stefan1234

You cal so refer this.

test.xaml (8.1 KB)
Test.xlsx (7.8 KB)

Thanks.

Thank you!

You are legends!

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