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

Problems With Unions

Avatar

Avatar
Validate 1
Level 1
lcharlwood
Level 1

Like

1 like

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
lcharlwood
Level 1

Like

1 like

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile
lcharlwood
Level 1

31-07-2020

Hello.

 

I'm having an issue whereby the data flowing out of a Union is acting strangely. I'm querying recipient delivery logs table (one the out of the box one, the other being a custom one) and bringing in the delivery code on both before going into a Union. The number that comes out of it is correct, combines both of the queries totals, but when you interrogate the data using 'Display The Target' it is only displaying the primary set data. Then I put it through a deduplication to get unique delivery codes but it is only giving me the number of the primary data.

 

 

lcharlwood_0-1596199119473.png

I've only come back to work recently after a few months off but I'm certain this was working previously. To note, I've seen this problem in a couple of other workflows where the number comes out of the Union says one thing but when you interrogate the data it is not all there.

 

Any help would be much appreciated.

 

Thanks.

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

923 likes

Total Posts

1,050 posts

Correct Reply

492 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

923 likes

Total Posts

1,050 posts

Correct Reply

492 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

31-07-2020

Hi,

 

The data's there, it's just not visible in the default 'Display the target' UI, which adds the target node of the primary set to the field list.

Remove the target field from the list (Configure list) and you'll see all the rows.

Not sure what's going on with the deduplication activity, were the rows duplicated on its condition?

 

Thanks,

-Jon

 

Answers (0)