I am attempting to use an external lookup table against some twitter data.
My Transforms.conf file reads:
filename = HLookup.csv
LOOKUP-HLookup = HLookup w AS word OUTPUT|OUTPUTNEW e
I however get the error:
Could not find all of the specified lookup fields in the lookup table.' for conf 'source_type_w' and lookup table 'HLookup'.
I am at my wits end as to why this is happening.It looks simple enough 😞
You have to pick either OUTPUT or OUTPUTNEW - you can't have both. For example:
LOOKUP-HLookup = HLookup w AS word OUTPUTNEW e
This setup also implies that the csv file starts with a header that looks like this: