https://community.splunk.com/t5/Splunk-Search/How-to-increase-number-of-events-in-format/m-p/617576#M214621 <P>I figured out a different method to get the data into one row using mvcombine.</P> Tue, 18 Oct 2022 18:52:03 GMT klim 2022-10-18T18:52:03Z https://community.splunk.com/t5/Splunk-Search/How-to-increase-number-of-events-in-format/m-p/617566#M214617 <P>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?</P><LI-CODE lang="markup">| inputlookup test.csv | table count | format</LI-CODE><P>The lookup has 50,001 values in it but format only goes up to 50,000.&nbsp;</P> Tue, 18 Oct 2022 17:28:22 GMT https://community.splunk.com/t5/Splunk-Search/How-to-increase-number-of-events-in-format/m-p/617566#M214617 klim 2022-10-18T17:28:22Z https://community.splunk.com/t5/Splunk-Search/How-to-increase-number-of-events-in-format/m-p/617568#M214618 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/228254">@klim</a>,</P><P>could you better describe what you want to reach using format?</P><P>in other words, what's the desidered output?</P><P>Ciao.</P><P>Giuseppe</P> Tue, 18 Oct 2022 17:34:07 GMT https://community.splunk.com/t5/Splunk-Search/How-to-increase-number-of-events-in-format/m-p/617568#M214618 gcusello 2022-10-18T17:34:07Z https://community.splunk.com/t5/Splunk-Search/How-to-increase-number-of-events-in-format/m-p/617571#M214619 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/161352">@gcusello</a>&nbsp; I want to use the events in the lookup table to be used in an api request.&nbsp;</P><P>Using format allowed me to get all the events into one row and then I can format it however I want.</P><P>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.</P> Tue, 18 Oct 2022 17:53:58 GMT https://community.splunk.com/t5/Splunk-Search/How-to-increase-number-of-events-in-format/m-p/617571#M214619 klim 2022-10-18T17:53:58Z https://community.splunk.com/t5/Splunk-Search/How-to-increase-number-of-events-in-format/m-p/617576#M214621 <P>I figured out a different method to get the data into one row using mvcombine.</P> Tue, 18 Oct 2022 18:52:03 GMT https://community.splunk.com/t5/Splunk-Search/How-to-increase-number-of-events-in-format/m-p/617576#M214621 klim 2022-10-18T18:52:03Z