Imply User Group › applying split to lookup value which is a concat of multiple values

Hi,

Here is an example of a lookup which is key|value pair - NY|Newyork_Queens_110022

What i am trying is looking up the key and whats to split the values like split(values,’_’)[0]…How do i reference the split values . Any guidance?

Thanks for the respones in advance

HI Harshit,

I wrote a blog that might help.

https://imply.io/post/lookups-for-network-flow-visibility

Eric

Eric Graham

Solutions Engineer -** **Imply

**cell: **303-589-4581

email: eric.graham@imply.io

www.imply.io

Thanks Eric. That blog was helpful and i was able to get the lookup working. As a next step, the lookup value is combination of multiple strings because in the lookups you can have only 1 value , if i have multiple information about a key to be displayed i combine them.

Is there a way to fetch multiple values ( not as multiple records )

No but you could create multiple lookup tables where key is the same and value is different and create separate custom dimensions that could both be displayed in the Pivot UI.

Eric Graham

Solutions Engineer -** **Imply

**cell: **303-589-4581

email: eric.graham@imply.io

www.imply.io

yup, that was the last option i was avoiding. Thanks Eric