SOLVED
How to use output of first query as input of second query and filter results?
1 Accepted Solution
Correct answer by
Hi @vinay16 ,
The solution for your logic will be as below, Only modification is that its good to use 'split' activity instead of Query-2, which will give the same output.
Query1:
As you had mentioned, you can select targeting dimension as recipient and filtering dimension as segment profile, and configure filtering conditions.
To add attributes related to filtering dimension of first query, click on Add data and follow the steps to add attributes. You can refer this documentation for more details
Change dimension:
Select change dimension, expand targeting dimension and scroll down, you can find 'subscriber applications' and select it.
And select 'Keep all records'
Split activity:
Go to general tab > select 'use additional data only' radio button
Now go to subset tab > select 'add a filtering condition on the inbound population' > edit > Now you can able to see targeting and filtering dimension is ;subscriber application' and the targeting population are the result of Query-1.
Hope this helps!
Hi @vinay16
You can use output of first query as input of second query by selecting temporary schema as the filtering condition.
To make the attributes available in the workflow you need to call them using "ADD Data" option and pull the necessary attributes.
Please find the screenshot of a sample workflow.
Regards
A
Correct answer by
Hi @vinay16 ,
The solution for your logic will be as below, Only modification is that its good to use 'split' activity instead of Query-2, which will give the same output.
Query1:
As you had mentioned, you can select targeting dimension as recipient and filtering dimension as segment profile, and configure filtering conditions.
To add attributes related to filtering dimension of first query, click on Add data and follow the steps to add attributes. You can refer this documentation for more details
Change dimension:
Select change dimension, expand targeting dimension and scroll down, you can find 'subscriber applications' and select it.
And select 'Keep all records'
Split activity:
Go to general tab > select 'use additional data only' radio button
Now go to subset tab > select 'add a filtering condition on the inbound population' > edit > Now you can able to see targeting and filtering dimension is ;subscriber application' and the targeting population are the result of Query-1.
Hope this helps!
Hi @vinay16,
Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!
Sukrity Wadhwa
