topic Re: How could I map one existing field with another csv file by using automatic lookups? in Splunk Search

How could I map one existing field with another csv file by using automatic lookups?

Jennifer — Wed, 09 Feb 2022 09:17:27 GMT

Hi, all!

I have one existing field which is CHECKPOINT_ID from my table 1 and another csv file which contains an interpretation of CHECKPOINT_ID.

I want to add a new column of GIVR_CALLFLOW_DEFINED_CHKPNT to my table 1 by using lookup!

Here is the table 1

Here's the csv file:

SanjayReddy — Wed, 09 Feb 2022 10:32:49 GMT

Hi @Jennifer

Can you try with this?

<your query >|lookup <filename> CHECKPOINT_ID OUTPUT GIVR_CALLFLOW_DEFINED_CHKPNT

SinghK — Wed, 09 Feb 2022 11:17:57 GMT

Initial query for table 1| lookup (your CSV) chexkpoint_id as checkpoint_id OUTPUTNEW (NEW FIELD FROM CSV)

field checkpoint_id , your new field