How to convert All datatable to Array [String]

Help
,
1

after consulting the subjects present in the forum, I allowed myself to ask my question which I have not found an answer yet.
I want to convert the whole datatable to an ARRAY STRING, Not only same column.
Thank you in advance

2

@Robot59
in case of we do need the datatatble represented as a string the output Datatable activity helps

If your scenario is different then let us know it. Especially on how the datarows should be handled. Maybe following approach will help:

assign activity:
left side: arrDTAsString (String Array)
Right Side:
(From d In yourDataTableVar.AsEnumerable
Select sra = String.Join(" | ",d.ItemArray.Select(Function (x) x.ToString).toArray)).ToArray

grafik

1 Like
3

Hi @Robot59 ,

Wat you can do is,

  1. Use output datatable to get the value as string
  2. Split the data at “,”

Let me know, if it helps

4

Hello @ppr
It not work
image

My wish is: to send each row of my datatable to a googlesheet file.
with this method my row is displayed in my file in question {system.data.datarow}

image
image1228×451 23.5 KB

Thanks in advance

5

@Robot59

[quote=“Robot59, post:4, topic:285836”]
It not work
image

the reason for your validation message is the missing ( on begin of the statement.

Just check always while copy and paste that the entire statement is catched.

6

@Robot59
with your additional information have a look here:
grafik

the hover indicates that the datatype is of Object Array

give a try on using row.ItemArray in this field

1 Like
7

Thank you @ppr It works Well

8

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