Hello,
I have a search which gives the output of the fields a and b. I am saving those outputs to a csv lets say output.csv. I would like to update with the latest value of the value a and b which means I do not want old/duplicate values for a and b and append non-existing values to the CSV file . I tried to do it with the left join but I was not successful.
Example: from the search fields below output is populated and writen to the csv.
bob 23
joey 33
and from another search fields below output is populated
joey 43
So I want my output.csv files to become below format.
bob 23
joey 43
Any help?
Bests!
CSV files must be updated in their entirety. The usual method is to read in the CSV, append the results of a search, deduplicate the results, and write them to the CSV.
| inputlookup output.csv
| append [ <your search> ]
| dedup name
| outputlookup outputs.csv
CSV files must be updated in their entirety. The usual method is to read in the CSV, append the results of a search, deduplicate the results, and write them to the CSV.
| inputlookup output.csv
| append [ <your search> ]
| dedup name
| outputlookup outputs.csv