Tommy Nguyen iamnvt
wynhopkins
/ gist:02e4d1951e65334db53ce17f5519190f
Last active
October 21, 2023 08:24
Wyn Trial Lambdas
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //ListOfTextMatches------------------ | |
| // Select a word to look for and a column to look in | |
| //outputs filtered list containing that text | |
| ListOfTextMatches= | |
| LAMBDA( | |
| SelectTextToLookFor, | |
| SelectRangeToLookIn, | |
| LET( | |
| FlagMatch, | |
| ISNUMBER( |
ImkeF
/ ParentChildAllParents.pq
Last active
February 23, 2024 21:03
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ///* | |
| let func = | |
| (ParChTable as table, | |
| ChildKey as text, | |
| ParentKey as text, | |
| LevelColumnName as text) => | |
| //*/ | |
| let |