|
Die klassischen Dateitypen können ab Januar 2021 nicht mehr verwendet werden. Sie können Ihre klassischen Dateien übertragen oder eine PDF herunterladen. Weitere Informationen

Dynamically Using Column Headers in Unpivot Command

Beantwortet
Demo anfordern

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

Kommentare

3 Kommentare

Datum Stimmen
  • 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

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.