Solved: Count columns

krixtsup3r · ‎02-07-2021

Hi Guys, is there a way to count all of the columns available on the table?

I have query that combines all of the table in a folder, as part of countermeasure that it will not lag I want to know first the # of columns available in each table. I have already tried to create a function using the Table.ColumnCount but it seems like it gives me the overall column count, opposed to what I want- wherein it will count per table

Payeras_BI · ‎02-08-2021

Hi @krixtsup3r ,

For me it works by adding a Custom Column and typing:

Table.ColumnCount([Transform File])

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

Payeras_BI · ‎02-08-2021

@krixtsup3r

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

Payeras_BI · ‎02-08-2021

Hi @krixtsup3r ,

For me it works by adding a Custom Column and typing:

Table.ColumnCount([Transform File])

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

krixtsup3r · ‎02-08-2021

Hey man @Payeras_BI that worked!

I just checked and what I did is actually correct but in a longer method and also 16383 is actually the maxed column that can be added in an Excel file and just noticed that all of my files got **bleep**ed up.

Thank you so much!