Lookup Column on Imported Data

Lookup Column on Imported Data

I am trying to link various tables using the date field as the lookup on data imported from Zoho Creator however no results are shown when I click to convert.
The option does show on manually entered data.