Remove columns are empty

[Chand (Chandani Dave)]

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

[Yoichi]

Hi,

Hope the following sample helps you.

Sample20200305-1.zip (21.4 KB)

Regards,

[abu.behlim (Abu Hurera Behlim)]

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😊

[Chand (Chandani Dave)]

Columns can be random

[Chand (Chandani Dave)]

Thank you so much. It worked