How to increase number of events in format?

[klim]

I have a lookup table that I want to use in a search. So I load the lookup table and use format. However I noticed there is a limit to 50,000 events in the format's result. What config allows me to increase that or convert a column of values into a single string?

| inputlookup test.csv 
| table count
| format

The lookup has 50,001 values in it but format only goes up to 50,000. 

[klim]

I figured out a different method to get the data into one row using mvcombine.

[gcusello]

Hi @klim,

could you better describe what you want to reach using format?

in other words, what's the desidered output?

Ciao.

Giuseppe

[klim]

@gcusello  I want to use the events in the lookup table to be used in an api request. 

Using format allowed me to get all the events into one row and then I can format it however I want.

I was trying to use foreach to loop through the values and concatenate them but I have not been able to figure that out as well.