'Incorrect column name' doing a Dynamic Pivot

Options
ramoshe
ramoshe 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:

image.png

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

  • GrantSmith
    GrantSmith Coach
    Options

    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!**
  • ramoshe
    ramoshe Member
    Options

    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.

Categories