I have two CSV files-- one is an inventory of sorts and the other is supplemental data that only applies to certain rows in the first table. Let's say for the example's sake that it's Inventory.csv and Userdata.csv
I want to have the output populate a new table and when the Userdata.csv has data that matches the ID in the Inventory.csv
The main issue right now is that I have to split them into two separate dashboard panels. I can't seem to have them join conditionally, I end up with a multivalued mish-mosh and everything points to the data needing to be indexed. It changes on a weekly basis and both CSV files may have changes.
| inputlookup Inventory.csv
| eval ID=upper(ID)
| lookup Userdata.csv ID as ID
| table ID Field1 Field2 Field3 Field4
Both CSV files contain a key identifier, an ID field. Does the data need to be indexed for me to search it/put it into a dashboard where I can look up fields and have it populate a table? The tabled fields are from both CSV files. Right now, as stated above I'm getting a ton of mv fields; I'd much rather have this in a way that's easier for anyone to import and search on.
My research showed that the best way to get this done is to get the data indexed since it makes it like any other data to search. These inputlookup[s] are killing me, I've had to jump through hoops to build dashboards and would rather not have something immensely resource intensive.
... View more