Dear All,
We are developing ORC Requisitions Extract where there is a requirement that a Requisition can be raised for multiple locations i.e. one job can be in 3 locations. All other columns are just only one record but 'Additional Locations' is the only one column where we have multiple records.
Hence the main extract will pull all the records as single records but only for 'Other Locations' should pull multiple records, stack up/ concatenate and then show it only in one column for every record.
Example is as below:
Suppose if we have 3 addresses for a ORC Requistion 1, as 3 records in the data base like below:
1. ORC Requistion 1 - Los Angeles,CA,US
2. ORC Requistion 1 - San Diego,CA,United States
3. ORC Requistion 1 - Atlanta,GA,US
then it is expected to come as one value as shown below and this query will be used in Extract Value set where many/ most of the functions will not work.
Final expected value:
Los Angeles,CA,US ; San Diego,CA,United States ; Atlanta,GA,US
As we are using the value set, it can not return more than 1 value...so how can we achieve this functionality.
Our requirement is same as below one:
How to get all the values returned by GET_VALUE_SET in Fast Formula (0 Bytes)Can some one provide some help here which can be of great help.
Best Regards,
Krishna