Invoke activity is giving error

Above is the problem i am facing right now.
I am using an invoke activity right after data scraping and then using a connect and insert activity to insert the ExtractDataTable to my database table.
Since the column names that are their in the webpage, from where i am getting the datatable, are different i have changed the column names as same as that is in the database table.

Any suggestions please?

1 Like

If we are trying to change the columnname
We can go for simple assign activity
The reason why it’s throwing error is when the first columnname is changed that datatable is in iteration, to term it precise its in process
So if we try to change the columnname in the very next step then this error would through

So kindly use assign activity for each columnname with its new name

Hope this would help you

@Palaniyappan thanks for the idea.
One more help i would need.
can you just tell me how should i write the syntax in the assign activity.
It would be of great help to me

1 Like

The syntax is same as you did just put the left of = in To part and right side in Value part

ExtractDatatable.Columns(“Mode”).ColumnName = “Name”

Similarly for all columns
Cheers @diptojyotidutta

Ok @Palaniyappan
Thank you

1 Like

ExtractDataTable.Columns(“Vehicle / Trans Doc No & Dt.”).ColumnName=“TransDocNo”
This is the syntax i am using in the assign activity

The error showing is that
Cannot create an L-value from the given expression with property “ColumnName” because the target object is null

Table no.5 is the table that i am extracting

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.