![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Member |
I'm trying to define a compound key in the join step in DQS. I get an unknown function using the concatenate function in the key definition of the join, also in the expression for a shadow column and in the expression for the alter format step. Has anyone gotten concatenate to work? Is there another way to concatenate columns? the | operator does not work either.This message has been edited. Last edited by: FP Mod Chuck, iWay Service Manager 7.07 iWay Data Quality Server | ||
|
Member |
Hi, did you try constructing your concatenated key in a previous step? e.g. Alter format/Column Assigner WebFOCUS 8 Windows, All Outputs | |||
|
Member |
Yes. I tried doing it with a shadow column and with the alter format. It seems the concatenate function described in help does not exist. I did find a solution using the + operator in the join, but I still want to know if concatenate is a valid function and how it is used. Thanks for responding to this question. iWay Service Manager 7.07 iWay Data Quality Server | |||
|
Member |
following is what i see from the help (documentation) press F1 key in your keyboard and search expressions. I got this from DQS 10.6.2 concatenate string concatenate(string expression [, string separator=" "] [, integer maxLen]) Returns a concatenated string made up of non-NULL values in a group, separated by the value in separator(optional). The resultant string never exceeds maxLen characters. Elements causing overflow are not added. WebFOCUS 8 Windows, All Outputs | |||
|
Member |
Yes. I see that too. But when I use concatenate I get an unknown function error. iWay Service Manager 7.07 iWay Data Quality Server | |||
|
Virtuoso |
CanMan If this is still an issue please open a case with techsupport. Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|