
Amarnath Reddy Athuri
- Total activity 11
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 1
- Subscriptions 3
Activity overview
Latest activity by Amarnath Reddy Athuri-
Amarnath Reddy Athuri commented,
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...
-
Amarnath Reddy Athuri created a post,
How to handle duplicates while exporting data to mysql sever. I am looking for UPSERT solution.
Hi, I have a export job which export data to mysql server over SSL. It works fine. But I have situation where I might get duplicate data in datameer and need to ignore the duplicate record and inse...
-
Amarnath Reddy Athuri commented,
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...
-
Amarnath Reddy Athuri commented,
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...
-
Amarnath Reddy Athuri commented,
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","...
-
Amarnath Reddy Athuri created a post,
How to handle double quotes in JSON values
I have below data which I want to convert into json values. 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 Ideally I need an out put like below: Expected output: ["0","0"...
-
Amarnath Reddy Athuri created a post,
String to Unix timestamp conversion
Hi , I am trying to convert "2017-01-03T00:05:00+01:00" into unix timestamp. I am using below formula, but its giving wrong date . Could someone please help me with this. t(timestamp(ASDATE(LEFT(SU...