Remove column with the same name (whichever that has null value)

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 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.

  1. lookup activity can be used for both columns (l1,l2)
  2. If l1 has value <0 then Remove the column used in L1.
  3. Else Remove column used in L2.
1 Like

You can use remove data columns activity and pass columns index that column has null value