I need to know the number of total columns and the number of empty columns per csv in a folder with many csv

I am reading multiple CSV’s from a folder (67 in total), I now need to count the number of columns in each CSV and the number of empty columns. Some columns are common, some others are specific to each CSV. Has someone done somethinG similar?

I cannot find a similar workflow…

Hi @B074534

It depends what your definition is of an empty column. But if emtpy = missing you can use the Missing Value Column Filter to split the columns in your dataset, and move from there.

gr. Hans

3 Likes

Hi,
there is a “Extract Table Dimension” Node to get the table dimensions (#rows and #columns)

With the “Missing Value Column Filter” you can remove all empty columns

5 Likes