How to add a column/field based on csv table

[AllenZhang]

I have a search like:
sourcetype="AAA"|table _time userid, and I have a table like userid, username,
how to make the result as .....|table _time userid username.

[gpradeepkumarre · Accepted solution]

upload your csv as a lookup table. Once you create a definition for your lookup, you can achieve with the below search

sourcetype="AAA" | lookup your_csv_definition_name userid output username | table _time userid username

[AllenZhang]

Thanks for quick answer. I am still struggling how to upload the csv file from my computer to splunk, to make it available to the lookups. Do I need to save it to some certain folder, anything like "import" I need to do?

[gpradeepkumarre]

go to settings -> lookups >lookup table files -> new

[richgalloway]

Something like this should get you started.

sourcetype="AAA" | lookup file.csv userid OUTPUT username | table _time userid username

If you create an automatic lookup you can omit the lookup command from the search.

[AllenZhang]

I was going to accept both answers, but the system only allows one. Thanks to both of you!