SQL DataFlows

SQL DataFlows

'Incorrect column name' doing a Dynamic Pivot

Member
edited March 2023 in SQL DataFlows

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!

Tagged:

Answers

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • 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.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In