[CLOSED] [SHARING] MATCH FILE in InfoAssist

I know we cannot do a MATCH FILE in InfoAssist (Ref: These Posts)

But, is there any way in IA to get the same results: All records from two sources? NOTE: The sources have a different number of fields and the field names are difference?

I do get what I want using MATCH FILE.

I know "InfoAssist isn’t a development tool and not really meant for data manipulation.". Do I need to wait till 8205 for such functionality (if it'll be there)?

This message has been edited. Last edited by: Doug,

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Waz

Expert

posted

Hide Post

Can you do a conditional join in Info Assist ?

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted

Show Post

Doug

Expert

posted

Hide Post

I think so... What would that condition be?
WHERE [field1] exists-or-is-missing OR [field2] exists-or-is-missing

It would be a OLD-OR-NEW in MATCH FILE.

A JOIN is based on the existence of what's in the HOST, right? So, we can get something from the target if it's missing in the target... But not if it's missing in the host, right?

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

Waz

Expert

posted

Hide Post

Perhaps it may not work.

Documentations states:

JOIN [LEFT_OUTER|INNER] FILE hostfile AT hfld1 [WITH hfld2] [TAG tag1]
TO {UNIQUE|MULTIPLE}
FILE crfile AT crfld [TAG tag2] [AS joinname]
[WHERE expression1;
[WHERE expression2;
...]
END
where:

INNER
Specifies an inner join.
LEFT_OUTER
Specifies a left outer join.

If you do not specify the type of join in the JOIN command, the ALL parameter setting determines the type of join to perform.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted

Show Post

Doug

Expert

posted

Hide Post

I think that's the DEFAULT in the IA JOIN GUI. But, it didn't do the trick. Nor did the inner or outer.

I may create a FOCUS file for them to use, outside of IA, and have them use it. I'll need to schedule it in RC.

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

Waz

Expert

posted

Hide Post

The only other think I can think of is to use FOCUS level SQL and do a full outer join ??. Don't know if IA supports this.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted

Show Post

BabakNYC

Virtuoso

posted

Hide Post

I doubt InfoAssist 8.2.05 will give you MATCH FILE either. What percent of your InfoAssist users need this functionality?

WebFOCUS 8206, Unix, Windows

Posts: 1853 | Location: New York City | Registered: December 30, 2015

Ignored post by BabakNYC posted

Show Post

FP Mod Chuck

Virtuoso

posted

Hide Post

Doug

I think you have the right idea to schedule a job to create the focus file they need. How often does it need to be refreshed?

Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats

Posts: 2127 | Location: Customer Support | Registered: April 12, 2005

Ignored post by FP Mod Chuck posted

Show Post

Doug

Expert

posted

Hide Post

Thanks Guys...

1) I'll go with a RC Job to run a fex that I created in AS.

2) Percentage of users needing this?
Righht now: One. But, I know there will be more. We're less than 5% into our BI Initiative, 95% to go

"I doubt InfoAssist 8.2.05 will give you MATCH FILE either."

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

David Briars

Master

posted

Hide Post

Yes, you can obtain a Cartesian product of two data sets with a JOIN.

-* File Many2Many.fex
TABLE FILE CAR
PRINT   COUNTRY 
        CAR
COMPUTE FLAG/A1='X';
ON TABLE HOLD FORMAT FOCUS INDEX FLAG
END
-RUN
-*
JOIN FLAG WITH SEQ_NO IN GGSALES TO ALL FLAG IN HOLD AS J1
-*
DEFINE FILE GGSALES
 FLAG/A1 WITH SEQ_NO = 'X';
END
-*
TABLE FILE GGSALES
"Example of Many-2-Many JOIN"
PRINT SEQ_NO 
      COUNTRY
	  CAR
WHERE SEQ_NO LE 2;
ON TABLE SET STYLE *
 INCLUDE=jellybean_combo.sty, $
 TYPE = TITLE, JUSTIFY=CENTER,$
 TYPE = DATA, COLUMN = SEQ_NO, JUSTIFY=CENTER,$
ENDSTYLE
END