String Data to DT

Help
#1

Hello Team,
I’m having Data,
eg:
MONOCYTES
EOSINOPHIL
BASOPHILS
IMMATURE GRANULOCYTE
NEUTROPHILS - ABSOLUTE
LYMPHOCYTES - ABSOLUTE COUNT,

I Want to write this to Datatable(Each row contains single value("MONOCYTES "),How can it be,done,Im confused
Please guide

2 Likes
#2

@Mayyur Is the Data in a String Format?

#3

Yes,It is string

#4

@Mayyur Does the Datatable you want to write those values is Already Existing or are you creating a New Datatable for it?

#5

Im creating a new DT

#6

Fine
Create a datatable with a single column using build datatable activity
—then if this string is stored in a variable named strinput
Then in a assign activity
arr_str = Strinput.Split(Environment.NewLine.ToArray())

Then use a FOR EACH activity and pass the above array variable as input
—inside the loop use ADD DATAROW ACTIVITY and in ArrayRow property mention as {item.ToString} And in datatable mention as dt

Now this dt will have those values in each row one by one

Cheers @Mayyur

1 Like
#7

@Mayyur Is there only One Column in Datatable?

#8

Hello,
This is working fine,but creating a extra blank row in between two strings

#9

Then in the split method mention this as well
arr_str = Strinput.Split(Environment.NewLine.ToArray(),Stringsplitoptions.RemoveEmptyEntries)

Cheers @Mayyur

3 Likes
#10

yes,a single column

#11

Check this workflow,
Test.xaml (9.1 KB)

#12

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