Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
-
dileonar50
- Posts: 2
- Joined: Wed Oct 01, 2014 3:25 pm
I have 2 rowset worked in different ways, and they want to unite them in one txt file, knowing that I have a record in a rowset and the other multiple records, where the rowset having a record is repeated in all records
-
Support_Rick
Support Specialist
- Posts: 592
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
Without additional information, it will be hard to help you get this going. My understanding of what you are inquiring about would tend to lead toward a nested loop structure if you're doing all this in GADirector. In pseudo terms:
Code: Select allForEach Rowset1
ForEach Rowset2
If Rec2 = Rec1 -> Print CSV Rec with Rec1 Data and Matching Rec2 Data
/ForEach
/ForEach
My preference would be to create a Temporary Table in your Database (MSSQL, MySQL, Oracle, DB2, etc) and write the Rowsets to 2 separate tables. Then, create a DB Query and join the 2 tables on shared information and create the single Combined Rowset and write that data to desired format (CSV, Excel, XML, Flatfile, etc)
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696