topic How to use inputlookup with csv file to import two multi value fields in a search? in Getting Data In

How to use inputlookup with csv file to import two multi value fields in a search?

C_Sparn — Tue, 29 Jul 2014 08:01:46 GMT

Hello,
I try to use inputlookup with a csv file to import two multi value fields in a search.
The two fields are both filled with numbers seperated with "," like 0012345678101112,5.
The field names are tickets and days.
Now I try to compare another field(Tickets)with the tickets field.
The problem is now that when I compare the 2 fields there are no accordances. I also tried to convert the fields to String and to Numbers but that didn't help either.

The code looks like this:

Tickets is typeof Number so it should work.
Where is the error?
Greetings

Re: How to use inputlookup with csv file to import two multi value fields in a search?

strive — Tue, 29 Jul 2014 08:45:28 GMT

I tried this and it worked.

I created test1.csv with two columns Ticket and Days

Base Search | stats count as Count by TicketCode | appendcols [|inputlookup test1.csv] | where TicketCode == Ticket | stats dc(TicketCode)

The above works when the field values are in same order.

You may try this

Base search | stats count as Count by TicketCode | rename TicketCode as Ticket| join Ticket[|inputlookup test1.csv] | stats dc(Ticket)

Re: How to use inputlookup with csv file to import two multi value fields in a search?

C_Sparn — Tue, 29 Jul 2014 10:29:09 GMT

Hello,
thanks for the answer, but both solutions are not working for me. With appendcols I get a table with each one ticket and one day value. But it is not the right day value like in the csv file. Join just gives no results. Also the where clause after appendcols gives no results in my search.

Re: How to use inputlookup with csv file to import two multi value fields in a search?

martin_mueller — Tue, 29 Jul 2014 11:05:50 GMT

What do your events and your lookup file look like?
What does the desired result look like?

Re: How to use inputlookup with csv file to import two multi value fields in a search?

C_Sparn — Wed, 30 Jul 2014 12:40:12 GMT

I found a solution with testing your code:
My solustion looks like this:

Then the join is correct and I can use all other fields of the csv file in the main search.
Thanks for the answers.

Greetings