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:
Customer 1, 2, 3
Spend 100, 200, 300, 400
Search: index=primary | join type=left max=0 Customer [search index=secondary] | table Customer Spend
Customer 1, 2, 2, 3
Spend 100, 200, 400, 300
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!
Please assume that you must join the tables. Just trying to provide a simple example. Thanks!