Need help to create a list using a custom function and add it has column in table.

[rmahadik]

Hi Experts,

I am trying to perform a iterative logic to get the row count of each table in Decision_Table. 

Decision_Table contains column with name Data_DB having tables. So I planned to write a custom function which will first generate a list of row count of each table in column Data_DB of Decision_Table and then add list as column in Decision_Table.

However I'm not able to create the list and getting below error. Please advise how to create a list if output is coming in iterative way. Or else please advise on solution for above requirement.

output:

[BA_Pete · Accepted solution]

Hi @rmahadik ,

On your table with the nested table column, just add a new custom column with the following:

Table.RowCount([Data_DB])

Pete

[rmahadik]

Many Thanks @BA_Pete  solution worked 🙂

[rmahadik]

@Vijay_A_Verma @AlexisOlson @BA_Pete @wdx223_Daniel , Guys please assist me on this.