Column to Array
BeantwoordHi
Is it possible to convert a column to an array with the following structure? I don't want to include the column name in the result.
["11111", "22222", "33333"]
-
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 Turn0Thanks Wade
I'll give this a try0Chad,
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 0Thanks 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.
0U moet u aanmelden om een opmerking te plaatsen.
Opmerkingen
4 opmerkingen