@SAMSAL Hi Samsal, Problem solved by using regex to extract maprecord{[xxxxx]}, Thanks for your details explaination about the lookup service ... View more

Dear @SAMSAL , Since the data is strictly confidential, I will share it with you in private message. Thanks ... View more

Dear @SAMSAL , Thanks for your detail explanation. But I do have a additional question about this, and I do not understand why. Still using 'INSERT RECORD FIELD' Suppose I have 10000 records in a flowfile CASE 1: I split the flowfile records into multiple flowfiles, each containing only one record. Therefore, there are a total of 10,000 flowfiles entering the Lookup service. Output: No errors were encountered.   CASE 2: If my flowfile contains more than one record, specifically 10,000 records, I encounter the following errors. So I attempted to address this error by splitting my flowfile into one record per flowfile. However, this significantly increased my processing time. Please also note that all records are identical in both cases.  May I know why is this happening haha, this really confused me.  ... View more

Dear @SAMSAL, Do you need additional details? Please do let me know, thank you so much in advance ... View more

Dear @SAMSAL ,Sure, please refer to the screenshot     ... View more

Dear @SAMSAL , Thank you so much for helping, we tried different ways, and we decided to use the solution that you mention above by concatenating those columns. ... View more

@cotopaul Dear Cotopaul, Thank you so much for helping!! ... View more

Dear @SAMSAL , I also have the same concern with @BigJames , Is concatenation the most logical approach in this context? Additionally, how should we handle NULL values? I assume that concatenating NULL values may not be feasible. Thank you so much in advance! ... View more