Splunk Search

Replacement for Join

ryanprayacn
Explorer

The below example provides the output I need, but I will exceed the JOIN command limitations (50k). Can someone advise on a different way to accomplish the join below - without using the JOIN command?

So as an example:

Primary Table
Customer 1, 2, 3

Secondary Table
Customer 1,2,3,2
Spend 100, 200, 300, 400

Search: index=primary | join type=left max=0 Customer [search index=secondary] | table Customer Spend

Output is
Customer 1, 2, 2, 3
Spend 100, 200, 400, 300

0 Karma

ryanprayacn
Explorer

Please assume that you must join the tables. Just trying to provide a simple example. Thanks!

0 Karma

gcusello
Esteemed Legend

Hi ryanprayacn,
could you share more details and examples?
watching your example, it seems that you don't need Primary table, you only need to show in a table values of Secondary Table in a different order!
Bye.
Giuseppe

0 Karma
Get Updates on the Splunk Community!

Observability Highlights | November 2022 Newsletter

 November 2022Observability CloudEnd Of Support Extension for SignalFx Smart AgentSplunk is extending the End ...

Avoid Certificate Expiry Issues in Splunk Enterprise with Certificate Assist

This blog post is part 2 of 4 of a series on Splunk Assist. Click the links below to see the other ...

Using Machine Learning for Hunting Security Threats

REGISTER NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more ...