its not a file management function inside the loop. you will need to use the Excel VBO.
Once there you can choose your own adventure on how you want to consolidate the data. Generally, i would move the data out of the excel files and into collections. then consolidate the collections. If...
you might take a look at this thread. it sounds very similar to my now solved issue
http://www.rpaforum.net/threads/find-and-replace-between-two-collections.1574/#post-5164
thanks VJ. you're absolutly right, i still had the filter wrong. it works perfectly now.
With my previous attempt it was looping but replacing with the result of the first item found.
thanks again, i appreciate your patience and help!
hi VJ thank you!
hadn't thought of the filter routine.
only issue i'm having now is related to the filter itself.
i'm getting the following.
Solved: i was using the filter wrong. i needed to point the columns to each other. EG [collection1.col2] = [collection2.col1]
i've tried keying the...
hi VJ.
yes.
collection 1 - has 2 column. GL account and FSLI
collection 2 - has records from a GL dump including GL account and various other fields.
i want to read through collection 2 on column2 and where the GL accounts match; i want to replace the value in col5 with the FSLI value...
Hi All,
i'm 100% new to this so hopefully i'm clear enough.
i have 2 collections. 1 is 2 colums that came from excel (lookup) and one a data dump that i imported into a collection from a tab delimited text file (data)
what i want to do is loop over the data table and replace a value in a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.