I am new to scripting but hoping you can help assist. I have 100+ databases each named "Fund XXX". Each fund contains a column heading "trans" signifying a specific transaction code. I need to select 4 random samples with the "trans" code "SELL" from each of the funds. I then need to export these 4 selections to a database saved as "Fund XXX Sell Random Sample". Nothing needs to be in excel, everything can remain in IDEA.
I have watched your 10 part beginner's video and looked all over this site for a possible solution, but all seem to have minor hiccups. I cannot seem to figure out how to open or save multiple databases without going through each script and updating. I am very new to IDEA so any help is greatly appreciated.
Last seen: 2 years 5 months ago
Joined: 09/22/2016 - 18:07