How to write single row data with multiple columns in existing datatable?

[Sanket_Shinde1 (Sanket Shinde)]

Hi , guys !
I have 7 columns with single row data and I want to write it in existing datatable .
how ?

so I have single row data , For each row is not good option for just single data.

Thanks in advance.

[rlgandu (Rajyalakshmi Gandu)]

@Sanket_Shinde1

I have 7 columns with single row data and I want to write it in existing datatable .
how ?

so I have single row data , For each row is not good option for just single data

@Sanket_Shinde1

you can use the “Add Data Row” activity to add a single row of data to an existing DataTable.

[Sanket_Shinde1 (Sanket Shinde)]

but how ?
Could you please explain
what will be the expression in array row of add data row?

[Sanket_Shinde1 (Sanket Shinde)]

in shared picture same column names are added in Build Dt

[rlgandu (Rajyalakshmi Gandu)]

@Sanket_Shinde1

Your Existing datatable and the seven columns with single row have same column names then you merge the data using MERGE DATATABLE ACTIVITY

OR

Read the 7 columns with single row data excel using read range
Then take For each row in datatable
Use add datarow activity

[Sanket_Shinde1 (Sanket Shinde)]

i am extracting from shared picture data then writing in buld dt