Forum Discussion

mayank_singh's avatar
mayank_singh
New Contributor II
4 years ago
Solved

Compare the values of two documents

Hi,
I want to compare the values coming from Union Snap. I’ve two input views, both returning the count of documents. Using Filter, I want to check if the count from both sources is similar then apply the following logic, but I’m unable to compare the values between two documents. Can anyone help me create the expression please? In my case there will be only two sources.

mapper
  • j_angelevski's avatar
    j_angelevski
    4 years ago

    Since they are separate objects, you have to find a way to combine them into one.
    Instead of Union, you can use Join with the following configuration:


    This will merge both objects into one, then you can easily check if countbefore is equal to countafter with the Filter: $['$countbefore'] == $['$countafter']

    Or, you can use an inner Join instead of the combination with Join + Filter:

    If their values are the same, there will be an output.

4 Replies

      • j_angelevski's avatar
        j_angelevski
        Contributor III
        4 years ago

        Since they are separate objects, you have to find a way to combine them into one.
        Instead of Union, you can use Join with the following configuration:


        This will merge both objects into one, then you can easily check if countbefore is equal to countafter with the Filter: $['$countbefore'] == $['$countafter']

        Or, you can use an inner Join instead of the combination with Join + Filter:

        If their values are the same, there will be an output.