Please find the attached modified workflow: load.xaml (22.3 KB)
Hi @aksh1yadav I get
Is it because the output of the get row item is DateTime type?
Yes and the schema and datatype problem was there as well as i mentioned schema should be same otherwise it will left that column to import
I’ve tried the methods presented, but I can’t get it to work.
They copied rows are empty on the second dataTable. What should I do?
Demo.xaml (13.0 KB)
You can have a try like this demo.
The issue you are having with “Add data row : This row already belongs to another table.” can be solved by passing row.ItemArray from initial row and pass it to the ArrayRow property of the Add Data Row Activity.
I would also consider the Merge data table activity which can be useful sometime.
“Add data row : This row already belongs to another table.” can be solved by passing row.ItemArray from initial row and pass it to the ArrayRow property of the Add Data Row Activity.
This worked very well for me. Excellent, thanks!
let me know if you have the solution. i am also looking out for this
Work for me too ! Good method! Thank you~
What to do when two data tables have different column name. When i tried using the ImportRow method values are not getting inserted since DT’s have different column name.
When i am trying to write in to the database( i created with Build data base Activity). It is the following error
and the value that i initialized for inserting is
where row belongs to data table one ( from which i am fetching values)
DT2 is the table in which i want to insert values.
Could you please help me in this.
Thanks in advance,
@pulapathiswathi, There are solutions in the same thread. Follow these links of solution from the above posts in case you missed it.
but i want to use “Data Row” instead of “Array Row”.
Will this method copy the entire line of those not matching the criteria?
Use Invoke method activity and use Import row method.
Before that Create the schema of DT2 same as that of DT1
In which step do you clone the tables?
I’ve tried when initialising it but it didn’t work:
ImportRow returns an empty sheet in my case
In Variable section initialise Despeass datatable as new DataTable()
Before Importing that is before running foreach activity where you are using invoke method use Despesas=ExtractDataTable.Clone()
While i’m using invoke method for new column add. I’m Getting trouble on Method name
What i’ve to give in Method name for Datatables,adding columns
Please let me know about Setordinal\
Does the invoke method|import row work only on data tables that we build like you did in the attached xaml? Can we use this if we create data tables using excel data?