Forum Discussion

GABILOBATO's avatar
GABILOBATO
New Contributor II
8 years ago

Writing no matching data

I’m trying compare different tables in different databases in order to get the no matching datas.

I already tried to use the lookup snap but it doesn’t give an option to get only the no matching records.

Have you guys ever had that same issue? How do I solve this?

Thanks

6 Replies

  • SandeepVemula's avatar
    SandeepVemula
    Contributor
    8 years ago

    @GABILOBATO Try using Diff Snap

    • GABILOBATO's avatar
      GABILOBATO
      New Contributor II
      8 years ago

      I already tried to use it. But somehow it keep sending all the original data to the deleted output even though is not all deleted data.
      All the paths has the same data type and are sorted before the diff snap. Don’t know what more I can try

      • SandeepVemula's avatar
        SandeepVemula
        Contributor
        8 years ago

        Try Reversing Inputs. New to Original and Original to New.