HI there

I worked myself through the chapter regarding hold files, but didn't find a solution for my issue (or did not understand).

I got following Data Structure


Article Project
x 10
c 10
d 10
x 11
a 11
b 12
g 12

Now I want to know which articles went in the same Project as my "Selection" article.

So I select "x", I got projects 10 and 11.

Article Project
x 10
x 11

In the Report Output I'd like now to filter on projects 10 & 11, but showing all articles.

Article Project
x 10
c 10
d 10
x 11
a 11

So I first select the article, giving the related projects. Then I want to use those filtered projects to filter on the total data base.

Could you please advise how to do that in Infoassist? For my understanding the basic "hold" files are not able to do that?

thanks & regards

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

You could make both columns drilldowns that will call the report. Here's an example called self_drill.fex.

ENGINE INT CACHE SET ON
-DEFAULT &COUNTRY =FOC_NONE;
-DEFAULT &BODYTYPE = FOC_NONE;
TABLE FILE CAR
BY COUNTRY
BY BODYTYPE
WHERE COUNTRY EQ '&COUNTRY';
WHERE BODYTYPE EQ '&BODYTYPE';
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=N1, TARGET='_self', FOCEXEC=IBFS:/WFC/Repository/Techniques/self_drill.fex(COUNTRY=CAR.ORIGIN.COUNTRY), $
TYPE=DATA, COLUMN=N2, TARGET='_self', FOCEXEC=IBFS:/WFC/Repository/Techniques/self_drill.fex(BODYTYPE=CAR.BODY.BODYTYPE), $
TYPE=TITLE, TARGET='_self', FOCEXEC=IBFS:/WFC/Repository/Techniques/self_drill.fex, $
ENDSTYLE
END

Alternatively, if you're licensed for Active Technology you could analyze your data the way you describe without much coding.

Try holding the projects.

ON TABLE HOLD AS 'WHAT_PROJECT'

Then add this where statement to the last table.

WHERE PROJECT IN FILE WHAT_PROJECT