Konsta Danyliuk

1. Community
2. Questions & Answers
3. SQL Worksheet - how to do date calculations?

Hello Kang.I'm glad to hear that you were able to proceed further with your project. Thank you very much for the feedback. I'll check what we could do to make functions usage in a SQL Worksheet mor...

• View comment
• Konsta Danyliuk
• October 30, 2019 16:10
• 1 vote

1. Community
2. Questions & Answers
3. Is there a performance difference between Regular Worksheet, vs. SQL Worksheet?

Hello Kang.SQL Worksheet has been introduced to let people that have SQL background feel more comfortable with the data transformation process in Datameer. Under the hood, SQL queries are being con...

• View comment
• Konsta Danyliuk
• October 30, 2019 08:23
• 1 vote

1. Community
2. Administration
3. Secure Impersonation on Datameer Without Super Group Requirement

Hello Arturo. To configure Secure Impersonation on Datameer Without Super Group Requirement, one should leverage a new Cluster mode called Native Multi User. This allows enabling Datameer's new sec...

• View comment
• Konsta Danyliuk
• October 15, 2019 10:56
• 1 vote

1. Community
2. Tips & Tricks
3. Using CONTAINED IN filter using Advanced filter

Hello Daniel.In this case you could use CONTAINS function at Advanced Filter. CONTAINS(#testColumn;"A") || CONTAINS(#testColumn;"B") || CONTAINS(#testColumn;"C") Please let me know if this helps yo...

• View comment
• Konsta Danyliuk
• March 05, 2019 16:24
• 1 vote

1. Community
2. Workbooks & Analytics
3. removal of duplicate rows in datameer workbook

Hello Alka.I would recommend the post Removing Duplicate Rows, hope mentioned approach will be useful in our case as well.

• View comment
• Konsta Danyliuk
• August 07, 2018 15:42
• 1 vote

1. Community
2. Workbooks & Analytics
3. cannot creat a path from an entry string

Hello Alicja.Looks like this is know issue that has been already fixed in recent Datameer versions.Could you try to add below custom property into your impacted Workbook and check if it helps the j...

• View comment
• Konsta Danyliuk
• August 01, 2018 12:25
• 1 vote

1. Community
2. Workbooks & Analytics
3. How to Use the IF function for an IF THEN ELSE Statement

Hello Kranthi.Hope you are doing fine. In general syntax of IF function for mentioned case is IF(<#SheetName!ColumnName>=="<match string>";<then>;<else>) or IF(EQUALS(<#SheetName!ColumnName>;"<matc...

• View comment
• Konsta Danyliuk
• April 18, 2018 09:27
• 1 vote

1. Community
2. Questions & Answers
3. 5 Trailing Zeros in File Name Using Export Job

Hello Scott, Thanks for reaching out to us with this question. Since the Hadoop framework will distribute Export Jobs by default, it will also add a trailing sequence number to the file name. The H...

• View comment
• Konsta Danyliuk
• May 10, 2017 17:59
• 1 vote

1. Community
2. Workbooks & Analytics
3. Lookup table ? Something like Excel's vlookup?

Hello.We don't have Excel vlookup analog in Datameer. But, seems, you could achieve mentioned goal by joining UserSheet and ProductLookup sheets by ProductGroup and then apply Group function (if re...

• View comment
• Konsta Danyliuk
• April 10, 2017 09:38
• 1 vote

1. Community
2. Administration
3. View all scheduled artefacts in one place?

Hi Soohan, I believe JobHistory page is exactly what you are looking for, please take a look to our documentation Job History. Also I would recommend to walk through our Administration Guide that g...

• View comment
• Konsta Danyliuk
• February 03, 2017 16:36
• 1 vote