Skip to main content

I am using Excel add-in for data migration most of the time no issues.

in a few examples i need to do some data retrieval/lookup and have used an expression in the ‘default value’ column in the migration job.

However, as yet i am struggling to do the same with a simple SQL select. Is it not possible or is my syntax incorrect. I have no guidance so I am making it up as a I go, I could be doing it incorrectly.

I did write a select first in quick reports to prove it was correct, although it is so simple I did not really need to.

When I click validate or execute - I don’t get any feedback, (the debug feature does not work) - but if I remove the select my other data updates - so something about my approach is failing. 

Thank you for any suggestions!

 

 

​@rkescoupland 

Try to use an alias for Business_opportunity

Eg: (SELECT WANTED_DELIVERY_DATE from Business_opportunity a where a.opportunity_no = opportunity_no)

 

Hope it helps!

Damith

Thank you dsj for this suggestion. I have tried using an alias before and I tried again using your example - but the migration job does not do anything or return any messages. When I remove the select completely and reapply the permissions and retest without the select in the default value - I can update/create data again. I am starting to think that it is not possible to apply SQL type select statements in Excel migration defined jobs. I have been able to use function calls successfully...sadly, there is not much deep and meaningful documentation around what is technically possible for Excel migration, such as using selects or expressions in the jobs, unfortunately.

Cheers 

Terms & ConditionsCookie settingsAccessibility statement