i have 2 csv file first one has name and idsecond one has the id only
i can extract the common id but i couldn’t find the query to show the common name using the id
any body can help please?!
| input csv1.csv | append [| inputlookup csv2.csv] | stats values(*) as * by id