Data reduction

[#1]

Hello Guys,

Is there a way to reduce data by section access and to show all data on another field:

ex:

Section Access;

Star is *;

LOAD * INLINE

[

ACCESS,USERID,PASSWORD,AGENCE,YEAR

ADMIN,AGBRT,toto,AGBRT,*

USER,IDF,titi,IDF,*

];

Section Application;

Produit:

load * inline

[

AGENCE,Produit,YEAR

AGBRT,XXX,2014

AGBRT,XXS,2015

AGBRT,XXL,2013

AGBRT,XZX,2011

IDF,UUP,2014

IDF,UUZP,2014

IDF,UUSP,2012

IDF,UUFP,2010

];

Calendrier:

load * inline

[

YEAR

2010

2011

2012

2013

2014

2015

];

In this example i want to reduce data on AGENCE field but i want to show all YEAR even if i don't have data ?

[Gysbert_Wassenaar]

That should be possible.

Your section access table won't work though. The star will allow access to all listed values. In your table no values are listed. So the * will allow access to nothing. Simply leave YEAR out completely and you'll get all values available.

[swuehl · Accepted solution]

Maybe remove the YEAR from the section access table and add this at the end of the section application:

TMP:

LOAD YEAR

RESIDENT Calendrier;

JOIN (TMP)

LOAD AGENCE, AGENCE AS CHECK RESIDENT Produit

WHERE NOT EXISTS(CHECK, AGENCE);

DROP FIELD CHECK;

CONCATENATE (Produit)

LOAD AGENCE, YEAR RESIDENT TMP;

DROP TABLE TMP;

edit:

CONCATENATE (Produit)

[#4]

Thks for reply;

It's was the first thing i did but it doesn't work anymore

[#5]

Great, thanks a lot!