Solved Pasting collection from BP to excel

Status
Not open for further replies.

osman.deveci

New Member
Hi,

Can someone help me with the following:

I have to calculate the difference between "Provisioned" and "Invoice amount" as seen below and create a new column named "difference".

1511170744318.png

1511171179170.png

I have put all data into a data collection stage and then calculated the difference of all rows one by one creating a loop. This is what I have in my collection after doing it:

1511170935197.png

The only remaining thing to do is putting the difference back into excel. When I try using write collection action, I get the error: "the collection has no current row".

1511171061812.png

Can someone help me how I can put the differences back into excel?

Thank you in advance!

Kind regards,
Osman
 

Attachments

  • 1511170843651.png
    1511170843651.png
    13.3 KB · Views: 47

Rhys_m_jones

New Member
A couple of thoughts.

Firstly, you cannot reference a single column of data in the collection as a collection (I don't think), so you would need to re-paste the entire collection over the original now it has the new column in it.

Secondly, I would always keep the information in Excel when you can and use VBA as this is much easier and quicker. This way, there is no need for collection manipulation.
 
Status
Not open for further replies.
Top