Invoke activity is giving error

[diptojyotidutta]

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?

[Palaniyappan (Palaniyappan P)]

Fine
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
Cheers

[diptojyotidutta]

@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

[Palaniyappan (Palaniyappan P)]

Fantastic
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

[diptojyotidutta]

Ok @Palaniyappan
Thank you

[diptojyotidutta]

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