Skip to content


Similar Source Column Variable Names

Mike asked 6 years ago
We have several sources that use variable names like Job and JobValue, however, when using those in a script in SmartConnect (_Job or _JobValue) the shortest variable name is used. I.E. _JobValue is replaced out as C12345Value where C12345 is _Job but I need 65.8 as the _JobValue.
Are there any quotes or field delimiters I can use to specify which source column I want? 
In SQL I would use [JobValue]. I’ve tried all the standards: ‘ ” [ ] { } ( ) etc…
Patrick Roth Staff answered 6 years ago
That is an issue with SmartConnect that I don’t believe has been resolved.
The problem is the order that the variables have been replaced in.  Not sure if it in “GUID” order or else by name – but I think it is by name because we see it a fair amount.
The problem is exactly as you describe – the “short” column name gets replaced by the code first which then causes the proper “long” column to not be replaced.
The only workaround at this time is to rename one of the columns so that the smaller string doesn’t fit inside the longer string.
Mike Caruso replied 6 years ago

Thanks for the info. Bummer that there are no delimiters for the variables.

If you would like to submit an answer or comment, please sign in to the eOne portal.