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
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