'Incorrect column name' doing a Dynamic Pivot

ramoshe · 2021-11-27T14:16:26+00:00

There was an error rendering this rich post.

Hi there!

I've been following this tutorial for dynamic pivot and so far it has worked: https://domohelp.domo.com/hc/en-us/articles/360042923454-Dynamic-Pivot. However, I get this error:

I thought it was because the name was too long, but the character limit is 1024 and even performing a substring I got the same error. 😓

Please Help!

Find more posts tagged with

SQL

Table

Accepted answers

All comments

GrantSmith

Have you tried doing the pivot in a Magic ETL dataflow with a pivot tile?

ramoshe

Yes @GrantSmith, but I have several different column names that are constantly updated, that's why I used the domo tutorial for dynamic pivot that has worked fo me before.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of