I have an issue with Import integration script.
I have a dimension where multiple columns from table should be combined with a . separator
Eg: rsAppend.Fields("UD4") is combination of 2 columns: Region & Center
I have tried below option which didn't work:
rsAppend.Fields("UD4") = rs.Fields("Region").Value & '.' & rs.Fields("Center").Value
Can anyone tell me if it is possible to combine 2 values in integration script
It should be & "." & not & '.' &