Skip to Content

This example is referenced in my other post about input parameters. Please have a look at the other post to get a better understanding of the context for this example

 

In this example we will filter for apples or oranges. Looking at the documentation we see that the calling syntax should use escaping apostrophes (two single apostrophes). This means that does not end the entered string but is interpreted as a contained in the string:

‘PLACEHOLDER’ = (‘$$var$$’ = ‘ ‘ ‘oranges’ ‘,’ ‘apples’ ‘ ‘)

The processing syntax is this time not using apostrophes as the individual values should be interpreted as strings separated by commas, and thus should be processed as ‘oranges’, ‘apples’ which is a list of string values.

To identify records that match a string in this list of strings we will use the function in which is only available in Column Engine

 

To reproduce the example:

a) In the filter expression of the model of Example 3 select Column Engine

b) Enter:

in(“product”,$$IP_1$$)

c) Save and build

d) Run the SQL statement from Example 3 but replace the placeholder with the following:

(placeholder.”$$IP_1$$”=>’ ‘ ‘oranges’ ‘,’ ‘apples’ ‘ ‘)

 

Thus, the SQL statement should look like:

SELECT TOP 1000

“date”,

“product”,

SUM(“productRating”) AS “productRating”,

SUM(“amount”) AS “amount”

FROM “INPUTPARAMETERS_HDI_DB_1”.”inputParameters.db::example4″

          (placeholder.”$$IP_1$$”=>’ ‘ ‘oranges’ ‘,’ ‘apples’ ‘ ‘)

GROUP BY “date”, “product”;

How the input parameters should be filled depends on the intended meaning. To signal to the data preview and front-end tools that you are expecting multiple entries you can tick the respective option Multiple Entries of the input parameter:

In the data preview dialog you would then first enter two input lines and then fill in the values:

Alternatively, you can create the SQL statement manually.

As a result of running the SQL statement you will see all records with oranges, or apples, in column product:

 

Click here to navigate back to the context in which this example is discussed. You will also find further examples there.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply