How to resolve the issue for merge datatable ( table cannot be null & object reference are not set

Dear all,

i would like to merge for two DT , but there will be possibility that one of the DT is null.

this is because the DT that i obtain was based on filterdatable, it will only keep for those meet the condition.

How can i avoid this error and make it applicable to both situation?

kindly advise.

Hi @irene0227

dtTable - datatable 1
dtTable2 - datatable2

Use if activity and condition would be (dtTable2 isnot nothing or dtTable2.rows.count > 0) and (dtTable isnot nothing or dtTable.rows.count > 0)

In then part use merge datatable activity


Thanks a lot for the solution provided.

it is working fine now.

1 Like

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