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
SplunkTrust
SplunkTrust

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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...