Error: Output column <column name> of Lookup <transformation name> (that is trying to find one to share) was not found in condition or output columns of Lookup <transformation name> (with existing cache) even though they have the same cache file name prefix <cache file name>.
The second Lookup transformation uses a subset of output columns of the first Lookup transformation. However, the second Lookup transformation needs to update the cache. The number of output columns must be the same.
If you do not want to share the cache, change the cache file name for one of the Lookup transformations. If you want to share the cache, make sure the shared transformations use the same ports in the lookup conditions.