@Shu I used couple of replace text processor to fix it. All good. Thanks ... View more

@Shu One last thing. I just noticed My queries doesn't like [] at the end of each line. This is created by update record. How can I remove /avoid them ? Please let me know. Thanks for all your help ... View more

Thanks @Shu . For some reason, I was earlier caught up that some text needs to be entered.It didn't strike in my mid that an empty line can be used. I tried above and it works totally fine. Thanks a Lot.You are awesome ... View more

Thanks @Shu. I tried Merge Content processor with delimiter strategy as text then demarcator as shift+enter. Shift+Enter string is being added after every record. Here is the sample Purchase":"1363.95"}]}}}]shift+enter[{"key":{"A Ami doing something wrong. I am just using all the default options in the MergeContent except mentioned above ... View more

@Shu Thanks a lot, Split text is working. One last thing, Now , I am trying to merge the files back after UpdateRecord is done.All the records in the merge is merging into one single line. I want them to be in the seperate line. Please let me know. Thanks ... View more

Thanks @Shu for promptly responding. My issue is slightly different. I have number of records (10) in the same file due to mergeJson for example,My file has [{"account":{"id":1}},{"account":{"id":2}}] [{"account":{"id":3}},{"account":{"id":4}}] [{"account":{"id":5}},{"account":{"id":6}}] It replace 1,2 succesfully but not 3,4,5,5 Please assist. Thanks in advance ... View more

Thanks @Shu for promptly responding. My issue is slightly different It has various records in the same file because merging few Json files. For example, [{"account":{"id":1}},{"account":{"id":2}}] [{"account":{"id":3}},{"account":{"id":4}}] [{"account":{"id":5}},{"account":{"id":6}}] It works for the first line 1,2 but not for 3,4 ,5,6. Appreciate your helpcapture.jpg. Screenshot attached as well ... View more

@Shu Thanks for the information. I tried the first approach mentioned by you.It works fine. But, the problem is,it is applied to only first line of my Json file and skips the rest. I am applying this logic on the Merg Json file which has many records.But, for some reason,it applies to the first line My reg expression is something like this replaceRegex(/account/id, '(^.*$)', '99999999999'). Please help! Thanks ... View more

Hi Matt, Thanks for the information. The queries i have written would take care of delta load. But i have to execute couple of queries at the same time. I want a processor that can run multiple queries at the same time. Below is how my query looks like ---------------------------------------------------------- with max_row_id as( select max(row_id) as MAX from target table) insert into dc_transdetail_orc select * from staging table join target table where row_id > max_row_id ... View more