Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

How to Covert date in the JSON data

Hello, I am trying to work with the date (timestamp to be precise) and getting into trouble. My requirement is below. I have a stage table where the data is stored as JSON in a Variant Column and the data looks like below in that column. { “message_b...

How To Rename Array key or Column

Hi , I have an array and I want to change the key/column names of it. { “Items”:{ “Item”:[ { “Item”:'“Pen”, “Desc”:“Black” }, { “Item”:"Pen ", “Desc”:“Blue” } ] } i want to rename the Item as WM_Item and Desc as WM_Desc

sjakathi by New Contributor II
  • 3476 Views
  • 3 replies
  • 3 kudos