An alternative to doing this directly in CCX would be to use the functionality in CM to route the call based on calling number. Usually this is done by called number. Once this is setup you’ll be using different trigger numbers, one for each of the five department and add a section in the script to set the CSQ to use based on these five called trigger number. Likely a switch would be the simplest thing to use for this. In the switch set the called trigger number as the match criteria, one for each of the five triggers, then set the CSQ name as the resulting action for each of these.
Otherwise you’d need to look at XML file look up as I do not think that it would work to read it from the Excel file directly.
The trigger number is the directory number that is used by CCX to accept calls. You can program your script to look at what number it received the call on and map that to the CSQ. In CM terminology the triggers are CTI route points.
If I’m not wrong you’ll need to have Premium for DB steps.
With an XML file you should not need to use any IF steps. If you have the calling number in combination with the name of the CSQ you would look for the calling number and then read the CSQ name from the XML file and then store that in a variable that would be used for the CSQ name.
If it would be looping through the XML file it would definitely be to big. But with the option that Anthony Holloway list in this post it should be doable. https://community.cisco.com/t5/contact-center/uccx-priority-queueing-big-list/td-p/4079302
