How to assign array of string variable to specific column in datatable using Linq

Help Forum
1

I’m using add data column to create new column namely (“Brand”) for my datatable. 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
gambar1814×32 2.61 KB

gambar
gambar1920×1080 17.8 KB

2

Hi

Hope the below steps would help you resolve this

—instead of directly adding a new column and then adding rows to it
First let’s create a datatable with single column and data in it

—use a BUILD DATATABLE activity and create the table structure with single column and get the output with a datatable variable named dt

—now use a for each activity and pass the array variable. You have as input and change the type argument as string

—inside the loop use a Add Datarow activity and in ArrayRow property mention as {item.ToString} and in datatable mention as dt

—after that loop use a Add datacolumn activity and mention in datacolumn property like this

dt.Columns(0)

And in datatable property mention your main datatable

Cheers @newuser1

3

What if I want to implement a linq query? can you explain?