Hi Martin
As far as of my understanding for your explanation, is that the collection does not contain the column name ("reference-number") which you have specified for storing the read data into collection with Field Name ("reference-number").
If that is the case, we have two methods for doing it.
after getting the data in collection for the Excel file please add a new field (Column-Text)
Hi guys, this has been driving me nuts for ages now and I know it might seem really basic but I don't remember it ever being covered in the training course I'm taking. Basically I have built a process that logs in to an order system, gets items from a work queue, places an order and then captures the reference number. The reference number I am sending back from the 'capture reference' Business Object to the Process but I am stumped as to how to add this data to my existing collection as the column name does not exist. I keep getting the error 'Field Data.reference-number not found' and I know this is because it doesn't exist in the Current Values tab in the collection.
The best I can do is store this returning data into a separate data object in order to not disrupt the process but this doesn't really help me as I need to be able to view the reference number in the control room via the data logs of the work queue. Can anybody help me append this returning data to my existing collection? Would really appreciate the advice. Thanks
Hi guys, this has been driving me nuts for ages now and I know it might seem really basic but I don't remember it ever being covered in the training course I'm taking. Basically I have built a process that logs in to an order system, gets items from a work queue, places an order and then captures the reference number. The reference number I am sending back from the 'capture reference' Business Object to the Process but I am stumped as to how to add this data to my existing collection as the column name does not exist. I keep getting the error 'Field Data.reference-number not found' and I know this is because it doesn't exist in the Current Values tab in the collection.
The best I can do is store this returning data into a separate data object in order to not disrupt the process but this doesn't really help me as I need to be able to view the reference number in the control room via the data logs of the work queue. Can anybody help me append this returning data to my existing collection? Would really appreciate the advice. Thanks
Hi Martin
As far as of my understanding for your explanation, is that the collection does not contain the column name ("reference-number") which you have specified for storing the read data into collection with Field Name ("reference-number").
If that is the case, we have two or three methods for doing it.
1. Add new Column name into Excel with Name "reference-number" before getting into Collection.
2. Add new column to collection after getting data from Excel to collection using "Utility - Collection manipulation", "Append Field(Text)"
Inputs for above are
Collection=main Collection after data import.
Field Name="reference-number"
Value=""
Output for above is
Appended collection with new Column name added.
After that you can add the data as you said above.
3.Creating a new defined collection with the fields required for storing the all the data (i.e. Inputs as well as Outputs).
Thank you
Hoping you understand above and might help you.