125 - Recreate Table FillDown
Let's pretend Table.FillDown doesn't exist. Let's get dangerous. Let's have fun.
Video 136 will show how to add a table type to Table.FromColumns.
00:00 Table.FillDown
00:48 Recursive lookup-solution
02:39 Hypothesis
03:01 Recursion confuses PQ
03:23 Replace the column instead
04:52 Fixing type any
05:42 Why PQ is confused (Ouroboros)
06:10 Turning the code into a function
09:25 Only do a lookup if necessary
12:18 List.Generate-solution
17:09 Add a list as a column