Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

Print on screen parameters passed to a custom function

Dear all,

 

I do hope someone can help me also in this case.

 

I have the following custom function:

 

(
Input_Table as table,
InputColumn1 as text, // Product_Series_Description
InputColumn2 as text, // Port_Type_1_2
InputColumn3 as text, // Connection_Type_Description*/
InputColumnToChange1 as text // 3rd_Port
) =>

let
NewTable1 = Table.ReplaceValue (
Input_Table,
each [InputColumnToChange1],
each if [InputColumn1] = "2 way Angle Body Valve"
then "NOT APPLICABLE"
else [InputColumnToChange1],
Replacer.ReplaceText,
{InputColumnToChange1}
),

NewTable2 = Table.ReplaceValue (
NewTable1,
each InputColumnToChange1,
each if InputColumn1 = "3 way Angle Body Valve" and
InputColumnToChange1 = "NOT APPLICABLE" and
InputColumn3 = "G/Rp (ISO 228-1 + ISO 7-1)"
then "G+Rp"
else if InputColumn1 = "3 way Angle Body Valve" and
InputColumnToChange1 = "NOT APPLICABLE" and
InputColumn3 = "ISO 7/1 Rc"
then "Rc"
else if InputColumn1 = "3 way Angle Body Valve" and
InputColumnToChange1 = "NOT APPLICABLE" and
InputColumn3 = "NPTF (ANSI 1.20.3)"
then "NPT"
else InputColumnToChange1,
Replacer.ReplaceText,
{InputColumnToChange1}
)


in NewTable2

 

invoked in this way:

let
Source = RULE1(Summary_Volumes, "Product_Series_Description", "Port_Type_1_2", "Connection_Type_Description", "3rd_Port")
in
Source

 

However the table is not the one I wanted to have. I suspect the parameters are not passed correctly to the function when invoked.

How could I plot on screen just the value passed to the custom function?

 

I had a background with another language, and to check the different steps, I used to print on screen the different steps.

 

Thanks a lot.

 

 

 

Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    ah, now I get it.  You are trying to abstract a column value replacement with arbitrary tables and arbitrary columns.

     

    This is a bit more complex, and requires Expression.Evaluate

     

     

     

     

    (Input_Table as table, InputColumn1 as text, OutputColumn1 as text) =>
  Expression.Evaluate(
    "Table.ReplaceValue (
Input_Table,
each ["
      & OutputColumn1
      & "],
each if ["
      & InputColumn1
      & "] = ""2 way Angle Body Valve""
then ""NOT APPLICABLE""
else ["
      & OutputColumn1
      & "],
Replacer.ReplaceValue,
{"""
      & OutputColumn1
      & """})", 
    [
      Table.ReplaceValue    = Table.ReplaceValue, 
      Replacer.ReplaceValue = Replacer.ReplaceValue, 
      Input_Table           = Input_Table
    ]
  )

     

     

    Welcome to the world of von Neumann, lex and yacc. There be dragons.

     

     

     

11 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    The values are whatever you invoke the function with. Shouldn't you know what they are?

     

    For troubleshooting you may want to start with smaller versions of the function, one parameter at a time.

    • Mic1979's avatar
      Mic1979
      Post Partisan
      1 year ago

      I followed your suggestion and I made it very simple:

       

      (
      Input_Table as table,
      InputColumn1 as text // Product_Series_Description
      // InputColumn2 as text, // Port_Type_1_2
      // InputColumn3 as text, // Connection_Type_Description*/
      // InputColumnToChange1 as text // 3rd_Port
      ) =>

      let
      Input_List = Input_Table[InputColumn1]

      in Input_List

       

      Invoked in this this way:

      let
      Source = #"RULE1 (2)"(Summary_Volumes, "2 way Angle Body Valve")
      in
      Source

       

      with this error:

       

      I really do not understand what I am making not correctly.

       

      Could you please support?

      Thanks a lot in advance

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

         

        let
Input_List = Input_Table[InputColumn1]

in Input_List

         

        This will not work.  

         

        Try 

        let
        Input_List = SELECTCOLUMNS(Input_Table,{InputColumn1})

        in Input_List

         

        Note that this returns a single column table, not a list.