Amarnath Reddy Athuri

1. Community
2. Workbooks & Analytics
3. How to handle duplicates while exporting data to mysql sever. I am looking for UPSERT solution.

Thanks Joel for your quick reply. The first option to "Overwrite Table" will not help as I do a incremental load to mysql server, so I need to retain the records in mysql server and export the reco...

• View comment
• Amarnath Reddy Athuri
• July 26, 2017 07:49
• 0 votes

1. Community
2. Workbooks & Analytics
3. How to handle double quotes in JSON values

Thanks very much Joel for helping with the Regex. It works fine when I have single date value with in quotes. Howeve I have different behaviour in input data where I receive some records without th...

• View comment
• Amarnath Reddy Athuri
• June 21, 2017 12:13
• 0 votes

1. Community
2. Workbooks & Analytics
3. How to handle double quotes in JSON values

Hi Joel, Thanks for replying. We are parsing a xml file to get this data as a string into a column. I need to convert this data into to JSON array somehow, so that I can JSON MAP using another JSON...

• View comment
• Amarnath Reddy Athuri
• June 20, 2017 15:49
• 0 votes

1. Community
2. Workbooks & Analytics
3. How to handle double quotes in JSON values

Hi,  Input in data in one column of worksheed: Columnx:  Input: 0 0 0 0 0 6 0 0 0 0 7 "2017-6-16 15:35:14" 24 0 300 0 0 0 0 0 0 0 I want to display it in columny: Output: ["0","0","0","0","0","6","...

• View comment
• Amarnath Reddy Athuri
• June 20, 2017 12:36
• 0 votes