lookup() causes internal error when searching the first column
When attempting to do a search on a lookup table using lookup('00000', col1:{datapill}) when the datapill doesn't exist, the formula will return a null response and proceed through the recipe if searching any column except the first.
When a lookup() finds no corresponding entries when searching the first column, the entire recipe will fail and that step errors out with an 'Internal error' message and no further detail.
bframe
lookup() causes internal error when searching the first column
When attempting to do a search on a lookup table using lookup('00000', col1:{datapill}) when the datapill doesn't exist, the formula will return a null response and proceed through the recipe if searching any column except the first.
When a lookup() finds no corresponding entries when searching the first column, the entire recipe will fail and that step errors out with an 'Internal error' message and no further detail.
The lookup table was created using a CSV import.