Problems With Unions | Adobe Higher Education
Skip to main content
L
lcharlwood
Level 2
July 31, 2020
解決済み

Problems With Unions

  • July 31, 2020
  • 1 の返信
  • 2214 ビュー

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.

 

 

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.

 

    このトピックへの返信は締め切られました。
    ベストアンサー Jonathon_wodnicki

    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

     

    1 の返信

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity Advisor回答
    Community Advisor
    August 1, 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

     

      L
      lcharlwood作成者
      Level 2
      August 2, 2020

      Thanks Jonathon.

       

      I can now see all the data when removing the target field but still doesn't seem to be flowing thorugh to the deduplication. The deduplication node is filtering on @deliveryCode but it is only bringing back the unique delivery codes from the target field. Any ideas?

       

       

      契約条件Accessibility statement

      Loading footer...