I have a similar query but the result expected is little different.
1. In the above, input data has been extracted from EXCEL CSV file which is passed into the queue and then one by one order is fed into the New Order System using option 1 in the navigation stage....but in my scenario
A) First option 2 (that is View Order Details is run using the reference number already available in the Orders.csv file)
B) You will get a read data details (View Order Details) with Product Code, Number of Units Required (Quantity), Unit Price, Cost Centre, Total Price, Date Ordered, Orderer details populated on the screen automatically.
C) Now action required is to use the Product Code, Quantity, Unit Price and Cost Centre as inputs for the (Option 1 - New Order form) by first doubling the quantity ordered.
D) Once the input is done and reference number is generated, write these details into Reordered Items file stored in C:\\Temp folder.
A part I am getting it perfectly fine, but I am facing problem with B part because
- When we try to map the details in the read data mode, all the items will be taken in Text Mode only as there will be no way of storing number in the read stage mode, so when I am trying to double the quantity, I am getting a message Text cannot be multiplied.
I would be obliged if anyone can help.