Data & Schema Discussions

How to Create columns manually

Hi,User has some data in excel and that data was entered manually in excel sheet and that data was not available in any source.User don't want to upload that excel sheet in incorta.Please let me know is there any way to create excel sheet columns man...

How to install a new python library or module to use in incorta materialized view ?

Hello there, I'm looking to install a couple new libraries on incorta, so that they can be utilized in during creating a materialized view. Can someone guide me to a documentation for it or enlist the steps ?Thank you in advance !Regards,Ruchita

MV Table in a business schema

Dear all,is it possible to create a MV from two tables in a physical schema and use this MV in the business schema ?

Incorta Metadata

Hi Team,I want to build the dashboard with metadata to know schema name, tables , alias tables, columns and formula columns used in which dashboard.Please let me know the table names and column names to build the dashboard.

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")...