Search 1.
| inputlookup test1.csv
| table ITEM1 ITEM2
Search 2.
| inputlookup test2.csv
| table ITEM 1 ITEM3
Conclusion.
I want it to show
|table ITEM1 ITEM2 ITEM3
but my results are showing
ITEM1 ITEM2
ITEM1 ITEM2
ITEM1 ITEM3
ITEM1 ITEM3
Question.
How can I join the Item1s? so that I get a result of
ITEM1 ITEM2 ITEM3
Hi @yohhpark ,
please try this:
| inputlookup test1.csv
| append [ | inputlookup test2.csv ]
| stats values(ITEM2) AS ITEM2 values(ITEM3) AS ITEM3 BY ITEM1
Ciao.
Giuseppe
You should show us what is the code that gave you the "wrong" results.
Here is an alternative to @gcusello's:
| inputlookup test1.csv output ITEM1 ITEM2
| lookup test2.csv ITEM1 output ITEM3
| table ITEM 1 ITEM2 ITEM3
Efficiency-wise, use the smaller of the two as test1.csv.
Hi @yohhpark ,
please try this:
| inputlookup test1.csv
| append [ | inputlookup test2.csv ]
| stats values(ITEM2) AS ITEM2 values(ITEM3) AS ITEM3 BY ITEM1
Ciao.
Giuseppe
One problem.
Let say I have a result below
ID Status Remark Values
11 PASS CHECKED something something hello
371 FAILED CONFIRMED someting hello SOME
let say I want to input another field from a inputlookup that is correlated with the ID number.
ex)
| inputlookup test
|table ID ActualName
which the results comes out
11 McDonald
371 BurgerKing
HOW TO simply input that result into the first query so that I can get a result as below?
ID ActualValue Status Remark Values
11 McDonald PASS CHECKED something something hello
371 BurgerKing FAILED CONFIRMED someting hello SOME
ITEM1 are the results of eval.
EX)
Search 1.
| inputlookup test1.csv
| eval ITEM1(something)
| eval ITEM2(something)
| table ITEM1 ITEM2
Search 2.
| inputlookup test2.csv
| eval ITEM1(something)
| eval ITEM3(something)
| table ITEM 1 ITEM3