I am trying to extract data from an excel file, according to a specific condition and then store it in another excel file.
I am able to read all data from the ‘Companies Dataset’ excel file and store it to a data table.
Using For Each Row from data table and using the If condition, I then try to Add Data Row in a new data table. But at this point I am getting error msg.- Add Data Row: Object reference not set to an instance of an object.
@kapurnick, Try one of the following options:
Option 1: Set default value for outputDataFile2 as “new DataTable()”
Option 2: Use Assign Activity to initialize data table.
E.g. outputDataFile2 = new DataTable()
@msan
Are you saying that in AddDataRow activity I simply change DataRow value to ‘row’ instead of ‘data_row’?
I did try to change but still I am getting same error msg.
@jcastro
Thank you so much for all your help. As per your above instructions, I was able to run my process and also generate a valid results. @Bhavik_Solanki, @msan, @jcastro
Once again, I would like to thank each and every one for all your help.