Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How do I create a column of data using a single cell of source data

Hi folks!  I am connecting to a folder that contains 2 dozen excel files.  Each file is idential in layout, the only difference is that some files have about 7,000 rows of data while others have over...
Need Help
artemus's avatar
artemus
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

You would use List.Generate:

 

List.Generate(() => myCell, each <<logic to test when to stop>>, each <<generate next value>>)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello artemus , is this function located within Query Editor?  If yes, where?  If not, how do I execute this command?  Thanks!