Lookup Table

[Abha]

I am attempting to use an external lookup table against some twitter data.

My Transforms.conf file reads:
[HLookup]
filename = HLookup.csv

Props.conf reads:
[source_type_w]
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 😞

[lguinn2]

You have to pick either OUTPUT or OUTPUTNEW - you can't have both. For example:

[source_type_w]
LOOKUP-HLookup = HLookup w AS word OUTPUTNEW e

This setup also implies that the csv file starts with a header that looks like this:

w,e

[Abha]

Thanks! 🙂