Inner Join

Siddharthnegi — Tue, 18 Jun 2024 06:57:35 GMT

Let say I have 2 lookup files , lookup1 has 50 values and other have 150 values
so when I inner join lookup1 to lookup 2 it gives me low results but when i reverse it results change and are higher.

Re: Inner Join

glc_slash_it — Tue, 18 Jun 2024 07:30:57 GMT

First load the lookups and then group both realms using stats.

Try to do something like this and adjust it to your needs, assuming there is a field that is common in both data sets:

|inputlookup lookup1 |inputlookup lookup2 append=true | stats values(fieldA) AS fieldA (...) by fieldB_common_in_both_datasets

If there is not common field, use rename or eval to create that common field before the stats:

| inputlookup lookup1 | inputlookup lookup2 append=true | rename fieldC as fieldB | stats values(fieldA) AS fieldA (...) by fieldB

topic Re: Inner Join in Getting Data In

Inner Join

Re: Inner Join