How to count the number of columns and store count into cell

Mohammed_Faiz_Shaikh · January 2, 2023, 6:02am

Hi,
In excel data i’ve multiple columns. for example id, name, address, phone etc. I want to count number of columns and calculate new column as count: numberOfColumns. how to count number of columns?

Jochen_Marquardt · January 2, 2023, 9:31am

Hi,

after loading the excel sheet, you can use the action “Table metadata” and get the column names. Then you can simply count the number of entries in this table (either with “running total” or “Aggregate” action).

roberto · January 2, 2023, 9:59am

Hi everyone!

@Jochen_Marquardt I think it would be easier to use “Total columns”, this way you don’t need an extra action, you get the column count directly:

Regards

Mohammed_Faiz_Shaikh · January 3, 2023, 3:09pm

Thanks it worked !!!