Forum Discussion

rmahadik's avatar
rmahadik
Regular Visitor
4 years ago
Solved

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

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:

 

 

Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi rmahadik ,

     

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

     

    Table.RowCount([Data_DB])

     

     

    Pete