Is it possible to typecast the datatype in profile query language? | Community
Skip to main content
S
ShashiCh
Level 3
February 15, 2024
Question

Is it possible to typecast the datatype in profile query language?

  • February 15, 2024
  • 2 replies
  • 649 views

Documentation do not cover typecasting the data for primitive types (double to integer)

https://experienceleague.adobe.com/docs/experience-platform/segmentation/pql/arithmetic-functions.html?lang=en

 

Can we typecast the profile data in PQL API query approach?

 

For example: Let's say profile has an attribute 'memberShipDuration': '500' , it is a string type. Now in profile query API, would like to convert it to integer so we can divide by 12 to find the number of years.

 

profile.memberShipDuration/12 = 41

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    K
    Adobe Employee
    Kumar29917170hcypAdobe Employee
    Adobe Employee
    March 11, 2024

    Hi @shashich ,

    PQL does not offer a cast operator like toInteger currently.

    The best way to get the operator working is to add a new field of integer datatype to the schema and populate the dataset with relevant integer values. Then perform the arithmetic operation on this newly added field.

    Thanks!

      NimashaJain
      Adobe Employee
      NimashaJainAdobe Employee
      Adobe Employee
      March 15, 2024

      @shashich Did you find the suggested solutions helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.

      Terms & ConditionsAccessibility statement

      Loading footer...