Combining data from different rows to a string

Question

I am getting data from a single column in a datatable. I need it to be combine to a string separated by comma or any delimiter.

The end result should be a string instead of the tabular data.

let words = datatable(word:string, code:string) [
"apple","A",
"orange","B",
"grapes","C"
];
words | project word;

I need to combine the result combined into a string with a delimiter.

Result should be : "apple,orange,grapes"

try this: words | summarize makelist(word) , but it will have the string inside []. — Ivan Glasenberg
– Ivan Glasenberg, Commented Aug 13, 2019 at 9:00

Yoni L. · Accepted Answer · 2019-08-13 15:04:13Z

17

Answer recommended by Microsoft Azure Collective

try combining strcat_array() with summarize make_list() as follows:

let words = datatable(word:string, code:string) [
    "apple","A",
    "orange","B",
    "grapes","C"
];
words
| summarize result = strcat_array(make_list(word), ",")

this returns a single table with a single string column, whose value is: apple,orange,grapes

answered Aug 13, 2019 at 15:04

Yoni L.

26.5k3 gold badges46 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combining data from different rows to a string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related