Alan
- Total activity 389
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 46
- Subscriptions 166
Comments
Recent activity by Alan-
Hi Aditya, Please supply the formula you've written, as well as describe the contents of the columns. Lastly please supply the description of what you're trying to do with the IF condition. Alan
-
Hi Pallavi, The SQL Minus operator performs a Left Outer Join. You can see the Venn Diagram describing this here: https://www.techonthenet.com/sql/minus.php So, start with your first sheet 1 and c...
-
Hi Pallavi, Yes you can certainly do this. The arguments for the IF statement are: 1. IF <Boolean> is True. 2. Then do this. 3. Else do this. So, for your "Then" condition(the second argument) you...
-
Hi Kranthi, You'd just need to use the CONCAT formula and do the standard multiplication necessary to convert to percentage. CONCAT((#Sheet!Column*100);"%") So, 1 would become 100 and then % would ...
-
Hi Tuğrul, Currently there is not a way to get this information from the REST API. You can, however, import the useraction.log file into Datameer using either an Import Job or Data Link - and then ...
-
Hi Bo, You'll want to use the MATCHES function to achieve this. Based on your description I'd use a REGEX pattern like: ^[1-6].* For details about what this means, plug it into regex101.com and tr...
-
Hi Ishfaq, It depends how the boolean is represented in your data. If it is represented by 0 and 1, then you would need to check for those values. However this may be as simple as surrounding false...
-
Davor, Thank you for the detailed exception, we can see the issue here: java.lang.UnsupportedOperationException: Cannot inspect org.apache.hadoop.io.LongWritable at org.apache.hadoop.hive.ql.io.pa...
-
Hi Steve, It's really difficult to say based on the description here. But there are a few approaches you can take. First is understanding why there are duplicates. Exactly when in your workflow ...
-
Ishfaq, Thank you for your question regarding the Datameer Function "IF". Please note that, per the documentation, it is a requirement for the IF function that the result arguments must be the same...