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 …

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😊

Remove columns are empty

Help Studio

Yoichi (Yoichi) March 5, 2020, 12:34am 2

Hi,

Hope the following sample helps you.

Sample20200305-1.zip (21.4 KB)

Regards,

8 Likes

Remove empty columns in a data table

Topic		Replies	Views
Remove data columns Activities excel	6	2265	May 16, 2022
Remove filtered data from particular column in datatable Help	6	2669	October 22, 2019
Remove column if row value is empty Something Else feedback	8	1782	February 24, 2023
How to remove empty columns from excel Activities excel , activities	1	2081	May 17, 2021
Remove column with the same name (whichever that has null value) Help datatable , excel , activities , error	2	882	April 6, 2020

Remove columns are empty

Related topics