
Anson Chan
- Total activity 70
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 24
Posts
Votes on activity by Anson Chan-
Complex CSV + XML combined loading
Hello Team, I have a use case whereby the source is a CSV file - tabular format (in rows) with entries of XML elements within. A sample structure as below: The target orientation of the data I'd l...
-
Pivot - Automatic add columns
Hello Team, We have a use case where we are using the Datameer function of Pivoting data, it works well. The workbook links with an Import and updates the run job. Under a scenario we have a small ...
-
Data Import File Path %hour-1%
Hello Team, As setting cron job in a data import I always use the %hour% in pointing to a right folder for import. However, sometimes, if I'd like to point Datameer to import an hour before the cur...
-
Difference between integers in a column
Hello Team, May I seek support on a case where I have 2 columns - 1st column is the incremental dates - 2nd column is the aggregated sum of a size I tried to use GROUP_Previous to generate a new co...
-
API Integration with ElasticSearch
Hello, We would like to enquire if it is possible in establishing a connection with ElasticSearch to import data into Datemeer. Thanks, Anson
-
Export Job .csv to S3 but end up with a File Type 00000
Hello, I have configured a connection for exporting a worksheet to an S3. Connection is good, export is good. When the export finishes, a file appears in S3 with a file type of 00000 When I downloa...
-
time difference across dates in a column
Hello Team, I have a use case where I would like to the storage size in the following scenario you will notice the date increments by 1 day all the way until Dec 27, where the storage sizes only r...
-
Import Job - File Type Query - plain text files / Solaries sysem logs
Hello Team, I am trying to upload / import datasets that are plain text files. the source of these data are financial industry applications such as POS, or solaris system logs. I do not know which ...
-
Use Case Support
Hello Team Datameer I have a question in relation of approaching a simple use case. I am unable to find documentations or tutorials available regarding to the mechanics to be employed. There is cro...
-
Parsing a column with LIST, String, and NULL
Hello Team, I am trying to parse a column that contains either a LIST, a NULL, or a String. As you can see it is the policy action that describes an AWS S3 Bucket. When I do JSON_ELEMENTS on the co...