The source contains no data rows in assign activity

[HKF]

Hello,
How to skip this error in (assign) activity.

Just to resume incase it’s found

[AndyMenon]

Hi @HKF,

Your question is not very clear. Can you please elaborate?

thanks

[lakshman (Ganta lakshman)]

@HKF

Hope you are getting this error at the time Filtering DataTable using either Select query or Linq query.

If yes then use Filter DataTable activity and then it won’t give such error. After this activity you need to check the DataTable row count. If it is greater than 0 means some rows are existing else not not.

Other alternative way is:

             Rows = New System.Data.DataRow() {}
             Rows = InputDT.Select("ColumnName = 'Value'")
              FilterDT = IF(Rows.Any(), Rows.CopyToDataTable, InputDT.Clone)

You can replace your assign activity with the above expressions then it won’t throw such error like The source contains no data rows. After this again you need to check FilterDataTable row count. If it is greater than 0 means some rows are existing else not not.

                FilterDataTable.Rows.Count

Note: I just gave an example Select query. You can replace above select as per your process.

[HKF]

Thanks
It helped