I have a lookup table sample_lookup.csv which consists of two fields, wildcard and location
I would like to add the location field to the existing search and create a new table so I can finally count the number of entries in each location.
My existing search is as follows.
I would like to have the table like this by matching the wildcard in the lookup table and add a location field in the new table:
Sample1 UserID Location
212389 AAA ABC
345699 BBB DEF
412366 CCC ABC
545688 DDD DEF
How can I make use of lookup to achieve this? It really stuck me for a long time =(
In your lookup table add wildcard chars to your "wildcard" column, like this *123* OR *456*. Then in your transforms, under the stanza for the lookup, add
match_type = WILDCARD(wildcard)
Another option is described here (but you should go with the other one proposed):