I am getting the same error but only on one of my pipelines that is using it.
I can’t tell which column is failing because it just says “Column 9”. I can’t see the data because it says Row 2393 and I don’t know how to get to that row to debug.
Did you ever figure this out?
Can Anyone help.
Thanks
Hi @fmdf
I resolved the issue by increasing the length of column in table. It is saying “Column 9”, then you just have to go and get the ddl of table and check which column is there at 9th position and then increase the length of column.
In my case I was facing this issue bcoz snowflake handles both Unicode and non Unicode characters with Varchar but in sql server for Unicode you have to give nvarchar. So lets say if you have column length is varchar(100) in snowflake then you have to give nvarchar(100) or more than that. Please try this if it helps.
I believe this is what you are asking for. The attached pipeline uses Apache Velocity to handle the if-then-else logic to output the appropriate containers in the xml. I created an array of objects to show both the 0.0 and non-zero case, which allowed me to also demonstrate for-loop logic to loop through the array contents.
XML Generator if-then-else_2021_05_13.slp (5.1 KB)
Hello Koryknick
Thank you for reply
But still its not resolve my issue , my expectation is like this if xml input is
case 1) if xml input is then output should be
Case 2 ) if input is then output should be
Case 3 ) if input is then output should be
Thank you
Hey @Mahesh7225 ,
I made some adjustments on the @koryknick’s pipeline and I belive that this is what you was looking for,
XML Generator if-then-else_DELETE_2021_05_14 (1).slp (5.3 KB)
Try and manually adjust cases in the JSON Formatter one by one.
Best Regards,
Bojan
How to find the incoming data format (like json or xml) dynamically | SnapLogic - Integration Nation - 14731
