Anson Chan
- Total activity 70
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 24
Activity overview
Latest activity by Anson Chan-
Anson Chan commented,
Thank you Konsta, I shall do so rightaway. Please bear with me as I'd need to mask and change the data set for support raising. I will retain the structure as is, just changing the fields.
-
Anson Chan created a post,
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...
-
Anson Chan commented,
adding the picture here for reference
-
Anson Chan created a post,
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 ...
-
Anson Chan commented,
Hello Konsta, Thank you very much. I followed your guidance and it works like magic! :) Kind Regards, Anson
-
Anson Chan created a post,
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...
-
Anson Chan commented,
Hello Konsta, yes. I am able to handle the columns in a new sheet. I was referring to the first row where the Mar 10, 2021 row where the storage bytes difference is 0
-
Anson Chan commented,
Hello Konsta, I am able to follow your instructions, and reached to an accurate result. My final follow up question in this case is. How do I get rid of the first row? Without using any filtering o...
-
Anson Chan commented,
Morning Konsta - Gonna try it out and let you know asap!
-
Anson Chan created a post,
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...