Data & Schema Discussions
The dataverse runs deep. Get help with connections, loading, schema development, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Time not matching

I time in DB column is coming as it is in the incorta table from query level. I executed the same script in DB and Schema level and the time was matching. Once the tables are loaded in incorta I explored the schema and found out that the time in DB w...

Trouble with CASE in Incorta SQL view

I am trying to create a new derived view using Incorta SQL. I am not trying to do anything tricky that I am aware of. I have checked the syntax for the query against Spark SQL for the CASE statement and it doesn't look out of order. Here is the query...

IFError

Hi Team,i have excel  formula column having Iferror function. Can you please let me know how to write it in Incorta.

KHK by Ranger
  • 76 Views
  • 1 replies
  • 0 kudos

Groupby Pivot in Materialized View

Hello, I am trying to create a materialized view with pyspark where I change the shape of a dataframe using a groupby and pivot function to create many new columns  out of a pre existing column.Like so: result = df.groupby("ItemId").pivot("Question")...