Data & Schema Discussions

Dynamic SQL to union current and future tables

Hello, I am trying to union 36 tables together. The challenge comes in because there is another table that I need to union each month. So next month ill have 37 tables and the following ill have 38. Is that something we can do within Incorta? Tryi...

SQL Server DB Connection

Hi,I'm unable to access SQL server from Incorta error message from SQL server log ""Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client librar...

SQL Server Connector

I am unable to connect to SQL server, SQL servers Encryption is enabled and bind with a server certificate The error message I am getting from SQL server log is Encryption is required to connect to this server but the client library does not support...

Session Variable Query Filter Not Working

I am trying to create a session variable that returns a specific column value (say column X) from the row with the most recent date value. However the filter expression in my query does not work at all and I am returning all X column values.Why is my...

Resolved! Convert languages (Chines) into English

Hi Team,I am looking to convert languages (Chines) into English or any other format. Do we have any function in incorta to use in formula column or any other suggestion.