Anson Chan
- Total activity 70
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 24
Posts
Recent activity by Anson Chan-
ASDATE parsing Query with format Jan 21, 2021 @ 20:34:54.000
Hello, I am trying to parse the following String to a DATE Jan 21, 2021 @ 20:34:54.000 I am using the following method and could not get to work, it gives me an error. would you be able to help adv...
-
Avoid <error> during data cleansing
Hello, Good Morning. I hit <error> cells whilst performing an operation that Involves1. ASDATE 2. SHIFTTIMEZONE The <error> comes when the originated data column does not contain any String I trie...
-
JSON Array Parsing Tips & Tricks
Hello, We have a question around Parsing JSON array column where not every cell has an array. For example: during the parsing of using JSON_ELEMENTS function on a JSON_ARRAY Column and notice that...
-
Unable to schedule Export Jobs
Hello Team, I am trying to schedule an export job but I do not seem to get the choice to configure such in Datameer. Please advise. Thanks, Anson
-
SHIFTTIMEZONE - FROM TO - switched
Hello Team, a recent operation in Datameer I'd like to shift a date Time Zone from Etc/UTC to Asia/Manila. where the result was wrong if I follow the syntax of "From" and "To" However the result o...
-
Splitting a Column
Hello, I am an analyst in Datameer and my role is to cleanse the data for further analysts to work on. We have a data set which a column consists of an array of attributes - applicable to an entity...
-
failed scheduling jobs with cron 1 * * * *
Hello, I have set a customer cron patter to perform an "import" at every 1st minute of every hour 1 * * * * But after an hour the scheduled job never run. Checking the Job Scheduler under the Admin...
-
Import Job - .ldf file type
Hello, I am trying to process an Active Directory export which has a file extension of .ldf. Is there a way to process this in Datameer please? thanks, Anson
-
Datameer --> Snowflake : Timestamp Issue
Hello Team, We are utlizing Datameer to perform analysis before exporting the output to Snowflake for data warehouse. In the process, we hit an obstacle which we are unable to solve. It is about Da...
-
Date Parsing of String "Date: Fri, 11 Dec 2020 20:59:07 GMT"
Hello Experts, I finished the Global Education for sessionization analysis and applying the knowledge to read time logs from web applications. I tried the following Datameer functions in attempting...