Sunday, September 16, 2018

How to use parameterized Data Page in Activity or in Data Transform ?


You can refer to a data page with one of several valid forms of this syntax. For D_Customer, you could load or refer to the data page using any of these:
Here CustomerID and CompanyName are 2 params of D_Customer
Using hardcoded value, Property or Param --
  • D_Customer[CustomerID:“ANTON”,CompanyName:"BigCo"]
  • D_Customer[CustomerID:.CustID,CompanyName:Param.CompName]
  • D_Customer[CustomerID:Param.CustID, CompanyName:"BigCo"]
When the data page only has one parameter, you don't have to specify the parameter name. You only need to specify the value:
  • D_Customer[“ANTON”]
  • D_Customer[.CustID]
  • D_Customer[param.CustID]
Ex-
Suppose D_Customer is of page type
Suppose we want CustomerID property to be used on Activity / Data Transform
  • Then we can use D_Customer[CustomerID:“ANTON”,CompanyName:"BigCo"].CustomerID




15 comments:

  1. It is one of the top compensation giving fields occupation profiles like Business Analysts, Business Intelligence Analysts, SAS Data Analysts, Big Data Scientists,ExcelR Data Science Courses

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Nice article. very interesting to read this article............

    ReplyDelete
  4. Awesome blog. I enjoyed reading your article. Very interesting to read this article...

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Article contains very good information thank you.
    To learn datascience vist
    Datascience course in Newzealand

    ReplyDelete
  7. Could you please explain how to use Parameter passed from Data Page to REST Connector within REST Connector? Either directly OR even to look up additional parameters using separate Data Page. Always see examples on how to use Data Page within Data Transform and Activity, but never in other rules, and I can never get thing to work.

    Thanks in advance

    ReplyDelete
  8. Önemli giriş adreslerine buradan ulaşabilirsiniz.
    betturkey giriş
    betpark giriş
    DD8G

    ReplyDelete
  9. Directory For PlacesMarch 16, 2023 at 3:05 AM

    The platform is also mobile-friendly, with a responsive design that works on all devices. https://bit.ly/directory-for-places This means you can easily search for and explore places on your smartphone or tablet, making it perfect for on-the-go planning. You can even save places to your favorites list, allowing you to quickly access them later.
    A business guide provides information and guidance on various aspects of business management and ownership.

    ReplyDelete

CSV format string from a Pagelist

In our business logic often we have the requirement to convert PageList to string CSV values. From -  PageList.pxResults(1).pyLabel  = P1 Pa...