Query advanced function | Community
Skip to main content
G
GiustaMa
Level 2
September 28, 2022
Solved

Query advanced function

  • September 28, 2022
  • 1 reply
  • 784 views

Hi all,

I want to query profiles that have total purchase of brand X > total purchase of brand Y.
This data comes from a custom table where we only have the brand chosen by the profile and the total purchase. Brand is text type and the total purchase is floating number type.

I tried doing the query using the advanced function but without result.
Is there anyone who can help me?

 

Thanks!

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

unfortunately you can't do an easy direct comparison on this in a single query.

You rather have to:

  • Do a query to determine the profiles
  • Add the purchase table as relations (with a filter / collection config)
  • Add the amount fields as additional data
  • In a following step (e.g. segmentation) you can then compare the values derived before

1 reply

B
Adobe Employee
bisswangAdobe EmployeeAccepted solution
Adobe Employee
September 28, 2022

unfortunately you can't do an easy direct comparison on this in a single query.

You rather have to:

  • Do a query to determine the profiles
  • Add the purchase table as relations (with a filter / collection config)
  • Add the amount fields as additional data
  • In a following step (e.g. segmentation) you can then compare the values derived before
    Terms & ConditionsAccessibility statement

    Loading footer...