How do I change all rows in my datatable to data type: String

Help StudioX
,
1

It seems that my data table have some "double’ (I guess it is because I have rows like: 4,14 etc.) data type inside. I need all my data table to be all string

How do I do that? my data table name is: data_table

I need all that is inside this data table to be string and not double

2

Oh I need this to be data table but data inside to be string I’m not sure if this is clear

3

Hi @marcin.chowaniec

Try this

// Assuming you have a DataTable named data_table
// Create a new DataTable to store the result
DataTable stringDataTable = New DataTable();

// Clone the structure of the original DataTable
stringDataTable = data_table.Clone()

// Use LINQ to copy the data while converting all values to strings
stringDataTable = (From row In data_table.AsEnumerable()
                   Select stringDataTable.Rows.Add(row.ItemArray.Select(Function(field) field.ToString()).ToArray())).CopyToDataTable()

// Now, the stringDataTable contains all values as strings
1 Like
4

If you are using the Generate Data Table Wizard in StudioX, I would uncheck the “AutoDetect Column Types” option.

5

No i dont use it i read data table from excel,

6

@marcin.chowaniec

Try like this

image
image882×636 35.4 KB

BlankProcess13.zip (37.6 KB)

Hope you understand!!

7

Thank you however I use Studio X and cannot open the file. Could you please copy the code from the second Assign here?

8

@marcin.chowaniec

(From row In DT.AsEnumerable()
                   Select StringDataTable.Rows.Add(row.ItemArray.Select(Function(field) field.ToString()).ToArray())).CopyToDataTable()
9

DT is my data table the original incorrect one right?

10

Yes @marcin.chowaniec

DT is your input data table

11

I get error: input array is longer than the number of col in this table

12

Can you please provide some sample excel file @marcin.chowaniec

1 Like
13

I foumd the solution I used for each row in column and then row.ToString

Thanks anywayt <3

14

No need to run for each if there is huge data it takes time, please try this

By using Invoke Code activity @marcin.chowaniec

image
image882×596 33.8 KB

image
image970×644 27 KB

Code:

    ' Iterate through each row and convert values to strings
    For Each row As DataRow In dataTable.Rows
        For Each column As DataColumn In dataTable.Columns
            row(column.ColumnName) = row(column.ColumnName).ToString()
        Next
    Next
15

Thanks but I’m done. I’m too tired for this For each is enough I don’t have that many rows