Forum Discussion

gowdhaman008's avatar
gowdhaman008
New Contributor II
6 years ago

SQL Server Merge Snap - Issues with Date as Null

Hi, I have developed the pipeline which reads the data from the incoming stream and send to SQL Merge. My pipeline looks like below. My Input JSON is as follows: [ { “member_id”: 13000...
transform
Mark's avatar
Mark
New Contributor II
4 years ago
Copy LinkReport

This doesnt work. The Excel Formatter snap does not allow you to change the datatype of a column no matter what datatype you send it. The Excel formatter always defaults to General. I used this Oracle PL/SQL package to generate a Excel document and this package kind of has the same issue where it defaults to “Custom” but for our purposes the API likes Custom and Date datatypes equally when a date is concerned, but doesnt like General. Dont know why. Recommend, somehow, allowing the Excel Formatter snap to change column datatypes. I dont need a response to this unless you have a fix where I dont have to use PL/SQL.