I have a variable with the type of array of string, and I want to assign the values to “Brand” column. Can anybody help me? Thank you This is my variable and data table [gambar] [gambar]

@newuser1 Try below steps. For Each item in Brand -Use Add DataRow activity and pass below values to it ArrayRow - {"","",item} DataTable - varDataTable Where varDataTable is output of your Build DataTable activity

I want to add all Brand value to specific column, that is “Brand” Column

Do you want to have this [image] or this [image]

Then use lakshmans description, it’s exactly what you need… If you’re a picture guy, here: [image] [image]

I have tried using for each. I forget to say that, I’m using assign activity to add 2 variable (string of array) to add values to CEO and Website column. After using the for each activity, this is the result of the program. The value of Brand Variable begin to be write add 6 row. [gambar]

So don’t use add row which - as the name implies - adds a new row, but rather go through the datatable with for each row and assign everything in there. But to be honest, you give us very little information somehow expect us to figure out what your problem is. Show us what you’ve tried and what yo…

Add variable (array of string) to specific column using Assign

Help Forum

jeevith (Jeevith Hegde, Ph.D.) September 28, 2021, 11:02am 8

Hi @newuser1,

If your rows are not more than 8000 or array length is less than 8000 then Linq is not going to be a game changer with respect to robot execution time. I think you previously asked to have a linq query to do this.

Check this thread. Except the first part everything else mentioned in this solution will solve your problem.

Topic		Replies	Views
How to assign array of string variable to specific column in datatable using Linq Forum question	2	1760	September 28, 2021
How to add array of string to the specific DataTable column using LINQ or Query? Studio studio , question , shortcuts	19	373	July 15, 2024
Add array of string to datatable Help	13	15878	July 16, 2020
How to insert a string variable to Data Table Help	2	13591	March 28, 2019
Assign strings in a array in for each loop Help datatable , activities , variable , question	9	7848	November 26, 2019

Add variable (array of string) to specific column using Assign

Related topics