Forum Discussion

dmcnichol's avatar
dmcnichol
New Contributor II
4 years ago

Issues using Diff Snap

Hi,

I’m new to snap logic, I have two data sources (Oracle, SQL) the new is Oracle and existing is SQL.

The pipeline’s first run, runs as expected, but the second, where I would expect all data to be in the “unmodified” output data preview is not working as expected. I’m trying to find where my settings are incorrect.

Entire Pipeline:

Diff:

I believe my issue is similar to this

Any help is appreciated thank you,

8 Replies

  • SL12345's avatar
    SL12345
    New Contributor III
    4 years ago

    thank you, that is really what i wanted 🙂 and is it possible to wrap this content into object so from this:

    {
  "CompanyName": "TestCompany",
  "CompanyAddress": "TestAddress",
  "Brand": "BMW",
  "Year": "2020",
  "Fuel": "Petrol"
}
,
{
  "CompanyName": "TestCompany",
  "CompanyAddress": "TestAddress",
  "Brand": "Jaguar",
  "Year": "2020",
  "Fuel": "Diesel"
}

    create this? Adding “Cars” as header or envelope for body/content?

    {
	"Cars":
{
  "CompanyName": "TestCompany",
  "CompanyAddress": "TestAddress",
  "Brand": "BMW",
  "Year": "2020",
  "Fuel": "Petrol"
}
,
{
  "CompanyName": "TestCompany",
  "CompanyAddress": "TestAddress",
  "Brand": "Jaguar",
  "Year": "2020",
  "Fuel": "Diesel"
}
}
    • JensDeveloper's avatar
      JensDeveloper
      Contributor II
      4 years ago

      Hi @SL12345 ,

      Have you tried putting a groupByN snap behind it and as target field $Cars.

      Regards

      Jens

      • SL12345's avatar
        SL12345
        New Contributor III
        4 years ago

        I need to correct my question … every JSON should have header “Cars”

        {
	"Cars":
{
  "CompanyName": "TestCompany",
  "CompanyAddress": "TestAddress",
  "Brand": "BMW",
  "Year": "2020",
  "Fuel": "Petrol"
}
,
{
  "Cars" :
{
  "CompanyName": "TestCompany",
  "CompanyAddress": "TestAddress",
  "Brand": "Jaguar",
  "Year": "2020",
  "Fuel": "Diesel"
}
}