Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Table column not equal to value in targeting dimension

cynthiea2328810
Level 1
Level 1

Hi All,

I am trying to do a split to exclude records where the additional value in the delivery (looking at the current table) IS NOT EQUAL TO a current value selected in the workflow. Is there a way this can be done?

I can only currently look at the current table (deliveries).

Thanks,

CA

1 Accepted Solution
Garima_Gakhar
Correct answer by
Employee
Employee

Hi cynthiea23288109

Thats not really possible.

You cannot query a temporary table, this is because there won't be any valid Filtering Dimension for that Query Activity. Without a query you won't be able to select the desired value and then match it with the Delivery's additional value.

View solution in original post

3 Replies
Garima_Gakhar
Employee
Employee

Hi cynthiea23288109

Kindly confirm by delivery (current table) are you referring to the Delivery which is selected as a part of the Split Activity.

And by current value selected within a Workflow, are you referring to values included within the Temporary Tables created during Workflow execution.

Garima_Gakhar
Correct answer by
Employee
Employee

Hi cynthiea23288109

Thats not really possible.

You cannot query a temporary table, this is because there won't be any valid Filtering Dimension for that Query Activity. Without a query you won't be able to select the desired value and then match it with the Delivery's additional value.

View solution in original post