クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

Dynamically Using Column Headers in Unpivot Command

回答済み
デモをリクエスト

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

コメント

3件のコメント

日付 投票
  • 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

サインインしてコメントを残してください。