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

[Jennifer]

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:

[SinghK]

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

field checkpoint_id , your new field

[SanjayReddy · Accepted solution]

Hi @Jennifer 

Can you try with this?

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