well let me tell you my case so i can simplify everything so I have 2 csv files reference_1.csv and reference_2.csv
plus the one I am indexing
I have 2 fields test1 and test2
test1 has {
"test1_ID": "123"
etc
}
test2 is
test2{
"test2_name": "name"
etc
}
the reference_2.csv has
test1_id test2_name Description code_name
12 name1 xxxx xxxx
12 name2 xxxx xxxx
13 name1 xxxx xxxx
13 name2 xxxx xxxx
I want to check if test1_id is available in reference_2 than I reference to it else I reference to reference_1
then I want to use test1_id and test2_name as keys to take code_name
so I get
test1{
"test1_ID": "123"
"code_name": "codename"
etc
}