I'm pretty sure i'm missing something simple but I am having trouble with a dataload.
Using apex 21.1 i've created a dataload but one of the columns needs to be a lookup.
I thought I could do this by just using a Column Type of SQL Expression but for that to work I need to reference the data in a column, how would I reference that column I tried using the selector as a reference but that doesnt seem to work e.g.
select system_id from system_lookup where system_name = v('SYSTEM_ID')
I've also tried using the lookup option but i keep getting an invalid number error?
Is this something that can be done or should I load into a collection and process the data from there?
Thanks in advance