How to join lookups?

[bosseres]

Hello everyone!

I have 2 lookups - 1.csv and 2.csv

1.csv contains such table

host	user	result
host1	Alex	success
host2	Michael	fail

2.csv

host	action
host1	action1
host2	action2

I want to make search that will join this two tables in one by field host (but only in search, without changing csv content).

It should turn out like this

host	user	result	action
host1	Alex	success	action1
host2	Michael	fail	action

so if there is similar host in two tables - join them in one

thank you for your help

[gcusello]

Hi @bosseres,

please try something like this:

| inputlookup 1.csv
| lookup 2.csv host 
| table host user result action

the lookup command is something near to a left join.

Ciao.

Giuseppe