Konsta Danyliuk
- Total activity 601
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 273
Comments
Recent activity by Konsta Danyliuk-
Hello Kang. What exactly issue do you observe while trying to get "current_date minus 3 days" at a regular Worksheet? It is much easier to compute this at a regular Worksheet via the formula IF(AFT...
-
Hello Souradeep. Lets first confirm that I properly got the requirement. You have a SourceSheet with columns date1 date2 P1 P2 P3...P100. You would like to calculate a difference between date1 and...
-
Hello Jon.I hope you are doing fine. Are you trying to represent this SQL statement using instruments available in Datameer, e.g. set of formulas in a Workbook, or you have tried to put it into a W...
-
Hello Mallinath. For example, you have the following input data and would like to check if the string contains UNIT 1 pattern. 1 UNIT 12 NOTUNIT 13 NOT UNIT 14 UNIT 1/25 UNIT 126 UNIT 1...
-
Hello Brendan. Are you facing syntax errors for any of these formulas? Whether all the columns involved in these formulas have DATE format?
-
Hello Sharon. Do you think it would be better if we move this discussion into a support ticket? If you will log in to support.datameer.com with your corporate email, you should be able to submit a ...
-
Hello Sharon.This exception might occur if one tried to use join dialog incorrectly. When one wants to join Sheet1 and Sheet2, it uses a simple TWO_MEMBER_JOIN. Here is a JSON definition of this op...
-
Hello Kunal.Please try to use ASDATE(null) instead of ASDATE(NULL). I've tested at my Datameer-7.4.3 lab and ASDATE(null) works fine, while ASDATE(NULL) returns syntax error. IF(ISNULL(#Self_Valida...
-
Thank you for additional details, Sharon. Let's start from the first part. Whether I understood properly that you have a source where records are being appended e.g. on daily basis. You want to hav...
-
Hello Sharon.May I ask you to provide a sample of the initial data, please, as well as a final result you are looking for. With such information it would be easier to offer suitable solution.