I have a search which returns a table with columns name,value,state - I have a lookup file (lookup.csv) with columns name,ID,num,state. I want to read state from my table and override(Not append) that value(Only state) in the lookup file which has the matching name as the table. Could some one help me with it.
my search | append [inputlookup lookup.csv | lookup lookup.csv name OUTPUT status | outputlookup append=false lookup.csv ]
But this is just appending the columns i want to override
