Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

null input parameters custom function

Dear all,   I have the following custom function:   ( Input_Table as table, Adder_Table as table,  Input_Table_Column1 as text, Input_Table_Column2 as text, Input_Table_Column3 as text, Input...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Mic1979 
    could you please provide sample of your tables?

     

Mic1979's avatar
Mic1979
Post Partisan
1 year ago

Hello DataNinja777 ,

 

Thanks for your help.

 

I had an error in the highlighted part:

 

let
Input_Table_Helper_Column = Table.AddColumn(Input_Table, "HelperLPInput", each
Text.Combine(List.Select({
Record.Field(_, Input_Table_Column1)?,
Record.Field(_, Input_Table_Column2)?,
Record.Field(_, Input_Table_Column3)?,
Record.Field(_, Input_Table_Column4)?,
Record.Field(_, Input_Table_Column5)?
}, each _ <> null), " "), type text),

 

Thanks again

ThxAlot's avatar
ThxAlot
Super User
1 year ago

You're looking to concatenate all non-null fields in each row?

 

= Table.AddColumn(Input_Table, "HelperLPInput", each Text.Combine(List.Transform(Record.ToList(_), Text.From), ", "))
  • Mic1979's avatar
    Mic1979
    Post Partisan
    1 year ago

    Hello ThxAlot ,

    no my target is to make a custom function working fine even if I get null input parameters.

    I have different cases where the custom function I posted can work with.

    Hoping this clarifies.

    Thanks.