Join two or more rowset
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
2 posts
Page 1 of 1
- 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 Specialist
- Posts: 590
- 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 all
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)ForEach Rowset1
ForEach Rowset2
If Rec2 = Rec1 -> Print CSV Rec with Rec1 Data and Matching Rec2 Data
/ForEach
/ForEach
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts
Page 1 of 1