Remove columns are empty

I have a datatable which contains 180 Colums. Out of which some columns are having null values in all the rows. I want to remove those columns.
e.g. dtTemp
column1 Column2 Column3 Column4 Column5
001 ABC 5
002 XYZ 6
003 PQR 7

I want to remove Column4 and column5. I am facing this error

2 Likes

Hi,

Hope the following sample helps you.

Sample20200305-1.zip (21.4 KB)

Regards,

5 Likes

Hi @Chand,

Use Filter data table activity and select the output column option and pass the column name in string format
e.g “Column4”

and select the ramove radio button. and pass that filter table variable in for each row and write the excel sheet.

Try this😊

Columns can be random

Thank you so much. It worked

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.