Forum Discussion

bubba's avatar
bubba
New Contributor
4 years ago

Questions on using the SQL Server – Merge snap, where is WHEN MATCHED logic?

Hello, I’m a new user to Snaplogic, so go easy. 🙂 My question is on using the “SQL Server – Merge” snap: I’ve created a pipeline to import from a sftp csv-formatted source to merge (update or in...
SL12345's avatar
SL12345
New Contributor III
2 years ago
Copy LinkReport

Looks good but question .... in my example  - one row has more fields than another row

Is it possible to "connect"/export two  lines into one file but without empty field at the and of shorter row? 

(Mercedes is shorter and CSV formatter creates last empty field) instead of this:
"Mercedes";"6658";"TypeS";"2022";""
"Audi";"5558";"TypeA8";"2022";"Diesel"

get This

"Mercedes";"6658";"TypeS";"2022";
"Audi";"5558";"TypeA8";"2022";"Diesel"

Thank you

 

  • Igor_Bozhinovsk's avatar
    Igor_Bozhinovsk
    New Contributor III
    3 years ago
    Copy LinkReport

    Thanks Alchemiz , the array is now spliited in two. One array with 100 elements and the other with the remaining elements.

    This is the current output :

    "ShipmentCreateDate": "01/01/2023",
"ShipmentID": "1",
"SerialNumbers": [
  [
    {
      "SerialNo": "123"
    },
	{ "SerialNo":"456"
    }
  ],
  [
	{
	  "SerialNo": "101"
	},
	{
	  "SerialNo": "102"
	}
  ]
 ]

    I was wondering if something like this output is possible :

    "ShipmentCreateDate": "01/01/2023",
"ShipmentID": "1",
"SerialNumbers": [
  [
    {
      "SerialNo": "123"
    },
	{ 
	  "SerialNo":"456"
    }
  ]
"ShipmentCreateDate": "01/01/2023",
"ShipmentID": "1",
"SerialNumbers": [
  [
	{
	  "SerialNo": "101"
	},
	{
	  "SerialNo": "102"
	}
  ]
 ]

    Where the first output would be the array with the 100 elements and the remaining fields that are not part of the array and the second output would be the array with the remaining elements and the fields that are not part of the array.

    Regards,
    Igor