Column 'NOMOR' does not belong to table DataTable

[fikri_desu]

Hi everyone,
i’m trying to extract data using Uipath studio 2021.4.4 from 2 web columns to excel. however i keep bumping into the same error

details:

Source: kopinomor

Message: Exception has been thrown by the target of an invocation.

Exception Type: System.Reflection.TargetInvocationException

RemoteException wrapping System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> RemoteException wrapping System.ArgumentException: Column ‘NOMOR’ does not belong to table DataTable.
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.set_Item(String columnName, Object value)
— End of inner exception stack trace —

the data im trying to retrieve and store to excel is this:

the error appears on “kopinomor” and “Assign” section.

any assistance is much appreciated!

project and excel:

IMB VX.xaml (49.7 KB)

dr rizki.xlsx (73.6 KB)

[Yoichi]

Hi,

It’s because you read data from only column A.

Can you try to set “” at Range proerty of Read Range activity?

Regards,

[fikri_desu]

thanks @Yoichi it worked like a charm.
however there’s another complication since the web column some times came out empty such as this screen shoot (the red shade indicates the data is empty/not found):

detail error message

is there any way i can get around this and continue with the process?

thanks

[Yoichi]

Hi,

As one of general ways, just before GetText activty, check if data exists and/or error message exists using ElementExists activity etc. If there is no data, process next record using Continue activity.

Regards,

[fikri_desu]

ok, thanks for your help and sorry for the late reply.

cheers