Splunk Search
×

Are you a member of the Splunk Community?

Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question

Merge tables by aligning fields with same value

Thuan
Explorer
‎10-24-2018 10:00 PM

Hello,

I have two tables listed below. The small table is a subset of the large table.

Large_table Small_table

large_source_field small_source_field
Account_Domain registry_key_name
Account_Name registry_path

AddressFamily registry_type
registry_key_name

registry_path

registry_type

I like to merge the two tables into a single one (see below) with entries with the same value on the same row

After_merging_table

large_source_field small_source_field
Account_Domain

Account_Name

AddressFamily

registry_key_name registry_key_name
registry_path registry_path
registry_type registry_type

Any help will be much appreciated

Tags (2)
0 Karma
Reply
Get Updates on the Splunk Community!

Update Your SOAR Apps for Python 3.13: What Community Developers Need to Know

To Community SOAR App Developers - we're reaching out with an important update regarding Python 3.9's ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Automatic Discovery Part 2: Setup and Best Practices

In Part 1 of this series, we covered what Automatic Discovery is and why it’s critical for observability at ...