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…
TIA
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…
TIA
Answers
Patrick Roth Staff answered 6 years ago
Mike,
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.
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.