'Incorrect column name' doing a Dynamic Pivot

ramoshe
ramoshe βšͺ️

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

  • GrantSmith
    GrantSmith Indiana πŸ₯·

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

  • ramoshe
    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.