AnsweredAssumed Answered

How to increment the dynamic process property value in run time

Question asked by varaprasad.mujigala888979 on Jun 9, 2017
Latest reply on Jun 15, 2017 by varaprasad.mujigala888979

Here I'm assigning the max vendor id from header table to dynamic document property and try updating it in run time, But I failed doing this. Find the details of actual scenario.

 

Here is the scenario,  we are getting the replacement orders file from one of our vendors, based on their unique id (CustomerPO) nothing but order number in their system, we need to define/generate our own unique id and it should be like vendor name and order number, means the number should stars from 001. (i.e. Vendor<001>, Vendor<002>....) and we are loading this data into more than 4 tables and need to make sure that ID should remain same in all of it.

 

Please find the source file data and expected data in target tables below and let me know do u guys have any insight on this.

 

Source file:

CustomerFirstName,CustomerLastName,CustomerID,AddressID,ItemNumber,Qty,CustomerPO
customer1_fname,customer1_lname,CUST0001,ADDR0001,SKU-001,1,AAA-111111
customer1_fname,customer1_lname,CUST0001,ADDR0001,SKU-003,1,AAA-111111
customer2_fname,customer2_lname,CUST0002,ADDR0002,SKU-011,1,AAA-222222

 

Target Table1:

CustomerFirstName,CustomerLastName,CustomerID,ItemNumber,Qty,Order_source_id
customer1_fname,customer1_lname,CUST0001,SKU-001,1,Vendor001
customer1_fname,customer1_lname,CUST0001,SKU-003,1,Vendor001
customer2_fname,customer2_lname,CUST0002,SKU-011,1,Vendor002

 

Target Table 2:

 

CustomerFirstName,CustomerLastName,CustomerID,AddressID,ItemNumber,Qty,CustomerPO
customer1_fname,customer1_lname,CUST0001,ADDR0001,SKU-001,1,Vendor001
customer1_fname,customer1_lname,CUST0001,ADDR0001,SKU-003,1,Vendor001
customer2_fname,customer2_lname,CUST0002,ADDR0002,SKU-011,1,Vendor002

 

And so on....

here is my Boomi Process 

 

 

Help me in accomplish this.

Outcomes