Dear developers, when i scrape a table from a website i have two columns with the same name, the read range will throw an error saying the column name already belong to the datatable.one column will have a null values, iwhile another one has the values needed. i would like to remove the column with null value and keep the other column with all the value. please help. appreciate it alot. thank you.
- lookup activity can be used for both columns (l1,l2)
- If l1 has value <0 then Remove the column used in L1.
- Else Remove column used in L2.
You can use remove data columns activity and pass columns index that column has null value