Martin Yergeau Posted October 19, 2021 Share Posted October 19, 2021 I am not sure how to perform those options using IA, but I think that you could use either the MORE or MATCH feature. If you have two identical files with same structure, fields name & format, the MORE feature is similar to a SQL UNION. MATCH feature is giving you more flexibility regarding file/fields format Here a quick sample using MORE TABLE FILE CAR SUM SALES AS 'MEAS' BY COUNTRY/A10 AS 'DIM' WHERE COUNTRY EQ 'ENGLAND'; ON TABLE HOLD AS FILE1 END -RUN TABLE FILE CAR SUM SALES AS 'MEAS' BY CAR/A10 AS 'DIM' WHERE COUNTRY NE 'ENGLAND'; ON TABLE HOLD AS FILE2 END -RUN TABLE FILE FILE1 SUM MEAS BY DIM MORE FILE FILE2 END -RUN Sample for MATCH TABLE FILE CAR SUM SALES BY COUNTRY ON TABLE HOLD AS FILE1 END -RUN TABLE FILE CAR SUM RETAIL BY COUNTRY BY CAR WHERE COUNTRY EQ 'ENGLAND'; ON TABLE HOLD AS FILE2 END -RUN MATCH FILE FILE1 SUM SALES BY COUNTRY RUN FILE FILE2 SUM RETAIL BY COUNTRY BY CAR AFTER MATCH HOLD AS MRGDATA OLD-OR-NEW END -RUN TABLE FILE MRGDATA PRINT * END -RUN Link to comment Share on other sites More sharing options...
Debra Waybright Posted October 19, 2021 Share Posted October 19, 2021 @lawrence.loncar If you are trying to capture individuals from two different data sources, it sounds like you need a full outer join, not a left join. A left join will pull everything from the left table and only what is in the right table that joins to it. You cant do a full outer join in IA in 8207.23. Link to comment Share on other sites More sharing options...
Larry Loncar Posted October 19, 2021 Author Share Posted October 19, 2021 Is there an easy way to implement a UNION using hold files For example, I am attempting to create a single report that captures individuals from two separate data sources. When I attempt to do a join between the two hold files, it appears to be running a left inner join instead of a left outer join. I am using InfoAssist version 8207.23 Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted November 1, 2021 Share Posted November 1, 2021 Larry, welcome to myibi! Are you still experiencing this issue If so, please open a support case. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now