Hello everyone,
I have a lookup file which have 5 entry with filed name and field value as below
"New_field"="yes", New_field1="yes", "New_field3"="yes", New_field4="Yes"
I need to append a new row to the lookup file with all the field value as "No". I am using the below command to do this
|inputlookup sample_demo.csv |append [|inputlookup sample_demo.csv|eval "New_field"="no", New_field1="no", "New_field3"="no", New_field4="no"]
this query is adding the new row but its adding 5 new row... I just need one row to append with new field value as "no"
Can anyone please guide me on this, as what am i missing in the query
... View more