I need to split an excel file containing source data into different csv files. Currently I read the excel file, store it in a datatable and use a for each row loop with the following expression to filter with column “ORG” and the write it to a CSV file. str_country gets values assigned dynamically.
dt_entityMaster = dt_entityData.Select(“[ORG] LIKE ‘" +str_country +"’”).CopyToDataTable
In general this works. However, it throws the error message: (Assign - The source contains no DataRows) as soon as str_country has a value which is not found in dt_entityData.
Any solution / other approach how this could be circumvented?
In this case it should just ignore it, don´t create a csv file and jump to the next country.
Thx in advance!