Forum Discussion
An error occurred in the ‘Query2’ query. Expression.Error: There is an unknown identifier.
Hi community. I am getting the an error in my Invoked Function. This is the code i used. Thank you! = let
funcWithPathItem = (ParChTable as table, ChildKey as text, ParentKey as text, Level...
Anonymous , What is the objective of (x) => if x = "" then null else x, will only Text.Split will not help ?
SplitIntoLevels = Table.TransformColumns(DuplicatedColumn, {"LevelPath", each Text.Split(_, "|"), type list})
Hi amitchandak Thank you for your reply. I managed to invoke the function. However, it is not working as intended... what i wan to achieve is something like the PATHITEM function where the path is split into its specific level. Do you know what i have to change? Thank You!