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

Updating Query Parameter Values in Chains

回答済み

コメント

3件のコメント

  • Jeff Hickey

    Hi John, below are suggestions of some commands that may help you to accomplish this goal.

    1. To read a specific cells from a Sheet, use the Get sheet data command.
    2. Get the value that was retrieved in the above step using the Extract value command.
    3. To run a Query from Chains, use the Run query command. Configure the Parameters section to use the Extract value variable from the previous step. For more information, please reference the documentation on using command outputs with other commands.
    4. Finally, the Export query result command can be used to send the results to a specific Sheet within a Spreadsheet.
    0
  • John May

    Jeff,

    Thanks for the response, it helped and I was able to fix my problem which was not using the extract value command.

    I'm able to get the query to export automatically within the chain, but if I try to export a view as part of the chain, I can't get the export view to work. 

    Are you able to provide a similar write-up for the export view?

    0
  • Jeff Hickey

    Hello John,

    Yes, there are a number of pivot view commands you can use in your Chain. Below is a list of them:

    The full list of Workiva Chain commands can be found at https://support.workiva.com/hc/en-us/articles/360036005471-Workiva-commands

    Without knowing the specific error you're seeing, it will be tough to point you in the right direction. But in general, you can get a list of pivots, then download the one you want from the list.

    0

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