- 6346 Views
- 6 replies
- 3 kudos
Resolved! Delta Live Tables error pivot
I'm facing an error in Delta Live Tables when I want to pivot a table. The error is the following: And the code to replicate the error is the following:import pandas as pd import pyspark.sql.functions as F pdf = pd.DataFrame({"A": ["foo", "foo", "f...
- 6346 Views
- 6 replies
- 3 kudos
- 3 kudos
It's said in the DLT documentation that "pivot" is not supported in DLT but I noticed that if you want the pivot function to work you have to do one of the the following things:apply the pivot in your first a dlt.view + the config "spark.databricks.d...
- 3 kudos
- 4013 Views
- 6 replies
- 3 kudos
Resolved! I am looking to use the pivot function with Spark SQL (not Python)
Hello. I am trying to using the Pivot function for email addresses. This is what I have so far:Select fname, lname, awUniqueID, Email1, Email2From xxxxxxxxPivot ( count(Email) as Test For Email In (1 as Email1, 2 as Email2) )I get everyth...
- 4013 Views
- 6 replies
- 3 kudos
- 3 kudos
source data:fname lname awUniqueID EmailJohn Smith 22 jsmith@gmail.comJODI JONES 22 jsmith@live.comDesired output:fname lname awUniqueID Em...
- 3 kudos