As you can see from my automation, I have been trying lots of ideas to delete data from my table, prior it going into Excel.
I have extracted data from a website, containing the word “Cancelled” in the 14th column (the column name appears to change frequently). I want this word to be removed from the DT prior to writing it into Excel.
In the Assign activity on the top, I currently get the "Cannot assign from type ‘System.Data.DataColumn’ to type ‘System.Data.DataRow’ in Assign activity ‘Assign Identify fields with “Cancel” to remove from table’.
I’m thinking to rather reference the column number in this Assign activity, than a col name. Current Value in there is SALESDATA_DSP_STR.columns(14).