Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Column to Array

Answered
0

Comments

4 comments

  • Wade Hays

    There are a few ways to handle this, but I prefer Handlebars. It works great!

    Just convert your data to JSON (JSON - CSV to JSON), pass it to a Handlebars command (depending on whether you want file or text output), and use a template like this:

    [{{#each cell_data}}"{{this.data}}"{{#unless @last}},{{/unless}}{{/each}}]

    Wade
    --
    Wade Hays - Tower Turn

    0
  • Chad Weber

    Thanks Wade

    I'll give this a try 

    0
  • Wade Hays

    Chad,

    I wanted to thank you for asking this question. It was the final push I needed to write a blog post I'd been planning for a while! It covers Handlebars techniques in Workiva Chains, with practical examples for this exact scenario and more. I hope the community finds it useful: https://towerturn.com/blog/power-of-handlebars-in-workiva-chains

    Wade
    --
    Wade Hays - https://towerturn.com/services/dedicated-expert

    0
  • Chad Weber

    Thanks Wade, I've incorporated your handle solution in my chain and it works :)

    Nice blog post! I've learned a couple of new things there too, thanks.

    0

Please sign in to leave a comment.