|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

Dynamically Using Column Headers in Unpivot Command

Besvarat
Begär demo

I am currently using the unpivot tool to change header values into a new column. I had to manually input the column headers for the tool to work. I tried using an extract value tool to get the header names and tried to use that as a variable in the unpivot command, but it does not recognize the string as multiple headers, but rather as 1 header. Is there a way to have the unpivot command dynamically take the headers needed instead of hard-coding it?

0

Kommentarer

3 kommentarer

Datum Röster
  • Tony Scalese

    I haven't actually tried this yet but you could try passing a Variable that is a comma delimited list and then use the Split Variable Transformation.  

    0
  • Tony Scalese

    One more thing, we're working on migrating some of the documentation from the OneCloud knowledge base to the Workiva knowledge base.  This will take us a little time but this article can be valuable to understand how to use the unpivot and pivot Commands of the Tabular Transformation Connector.

    If you have a screenshot of the header row and can indicate which columns you want to unpivot, I can do some testing internally.  

    0
  • Dean Losar

    Thanks Tony, I wasn't aware that Split Variable was even there. I tried it out and it worked. Thanks again!

    0

Du måste logga in om du vill lämna en kommentar.