Skip to Content
-5

Table Function

Can anyone please answer below query:

Need to create a Table Function where user is asked to enter a value. If nothing is specified by user then the Table Function should display default values else user specified value should be used to filter the data WITHOUT using Graphical calculation view.

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Posted on May 13 at 09:13 AM

    You cannot create a table function which prompts for an input. You are just able to create a table function with a scalar input parameter. Within the body you can check if the parameter is "initial" to use a default value in that case.

    Asking the user to enter a specific value needs to be done in the client you are using.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on 4 days ago

    Thanks Florian for providing the details , Actually I absorbed match function working properly if we use directly a catalog table instead of consuming a table function in calculation view. I checked using table function with match function in filter expression, it does not fetch all values if input parameter is blank, only it fetch relevant record with respect to a input prompt. Please let me know on this.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on 4 days ago

    Hi Siba,

    In Table function, you can use IF Else condition. If input parameter is blank or NULL then fetch all records else filter based on on input.

    Add comment
    10|10000 characters needed characters exceeded