I am attempting to run the below, however I am not getting any results.
source="source.tsv" [|inputlookup appname| fields inputfield AS "field"]
I can search source="source.tsv" and get the fields displayed, and |inputlookup appname| fields inputfield AS "field" and displays fine, but when I attempt to combine them to get a match, I get no results. I understand that this only provides a result when there is a match but I have inserted a field that should trigger a match.
Can anyone please help point me in the right direction?
@blueumbrella,
You could use just lookup
instead of inputlookup
E.g.
source="source.tsv" |lookup appname inputfield AS "field" OUTPUT "your required fields from lookup"