ContributionsMost RecentMost LikesSolutionsRe: I am trying to perform a lookup and extend the object using the expression library Yes, based on comparing with one of the properties in object ‘x’ and then I wanted to assign the property. For example: embedbusinessUnit: x => x.extend({"CompVKORG":this.comparator.filter(y=>(y.VKORG==x.VKORG))[0].KSCHLN}) Re: I am trying to perform a lookup and extend the object using the expression library @viktor_n Thank you for your response with a detailed explanation. I wanted to extend only one field/property from the comparator array element based on the matching criteria as shown below: embedbusinessUnit: x => x.extend({"Demo":this.comparator[0].KSCHLN}) Kinds&Regards Patan I am trying to perform a lookup and extend the object using the expression library I wanted to perform a extend by performing a lookup using the expression library and it is giving me “this.comparator is undefined” error. Below is my expression Library Content: { embedbusinessUnit: x => x.extend({"Demo":this.comparator[0]}), embedbusinessUnit1: x => x.merge(this.comparator[0]), "comparator": [ { "KSCHL": "EPE", "VKORG": "1000", "BusinessType": "E", "KSCHLN": "LPE", "VKORGN": "1000" }, { "KSCHL": "EP0", "VKORG": "RG", "BusinessType": "N", "KSCHLN": "LP0", "VKORGN": "1000" } ] } When I access the lib.businessUnitExpr.embedbusinessUnit($) gives me a comparator undefined error. But when I access lib.businessUnitExpr.embedbusinessUnit1($) then it is able to identify the comparator Any help would be appreciated. BusinessUnitComparator.expr (382 Bytes) Pipeline migrate/copy with versions as well When I am copying the pipeline from one project to another, the version information on the source project is not available in the target project space for the same pipeline. What is the best to way to copy/migrate the pipeline with version information as well. Re: How to access the expression library loaded in the parent pipeline from a child pipeline @AleksandarAngelevski Right now we are using the JSONGenerator snap with in the child pipeline but it is causing the performance issues. I used another library which contains only comparator array, and pass it as pipeline parameter: And used the expression library in the child pipeline to perform the compare as suggested by you. but the performance is still not improved. Re: How to access the expression library loaded in the parent pipeline from a child pipeline @AleksandarAngelevski The Comparator object will have more documents to be compared than it has now. Re: How to access the expression library loaded in the parent pipeline from a child pipeline @AleksandarAngelevski Thank you for your feedback. but this solution will not work as I have more than 1000 records to be compared. A ternary operator solution might not fit my scenario. How to access the expression library loaded in the parent pipeline from a child pipeline I have a scenario as explained below: I have an expression library which is 176kb to compare with the static data(we have a performance issue with JSON Generator and then performing the join). Which needs to be accessible from the child pipeline which will be executed multiple times, since I have to pass the pipeline properties I cannot configure to reuse executions. Since the child pipeline will be launching individual pipeline instances which is resulting in loading the expression library every time and causing the performance of Memory usage(avg of 40%). Expression Library → compareandfetchfilter_new.expr (433 Bytes) Parent pipeline → invoke-child-pipe-lib-with-170kb_2023_01_02.slp (4.2 KB) Child Pipeline → compare and get result from Expression Library_2023_01_02.slp (208.9 KB) Any suggestions would be appreciated. Re: I wanted to create multiple arrays from a single array based on specific Field Thank you @viktor_n it worked. I wanted to create multiple arrays from a single array based on specific Field I have the below input: “AT_Pricehash”: [ { "@TermsListID": "Test1", "ORGID":"1000", "@MinimumQuantity": 1 }, { "@TermsListID": "Test2", "ORGID":"1001", "@MinimumQuantity": 1 }, { "@TermsListID": "Test3", "ORGID":"1000", "@MinimumQuantity": "1" } ] I wanted to generate two arrays based on the ORGID, expected output as below: "1000Array" : [ { "@TermsListID": "Test1", "ORGID":"1000", "@MinimumQuantity": 1 }, { "@TermsListID": "Test3", "ORGID":"1000", "@MinimumQuantity": "1" } ] "1001Array"[ { "@TermsListID": "Test2", "ORGID":"1001", "@MinimumQuantity": 1 } ] Since this requirement is part of the ultra pipeline, I cannot use the straightforaward way i.e. by using the Split, sort, and then perform the GroupBy Field snap to generate arrays based on ORGID. We can use the child pipeline but I would like to see if we can get this done in the same pipeline directly. Is there any way to achieve this such as a direct expression or expression library, etc? Any help would be appreacited. Solved