Hi Sudeep, In the Section table you have to kept only one Reduction Field. If you are using 2 reduction fields its won't work. In these cases , you need to create the Composite Key (make more than one key) in the Reduction field and in the data model.
LOAD ACCESS, USERNAME, PASSWORD, OMIT, ORG&'-'& COUNTRY AS REDUCTIONFIELD
(ooxml, embedded labels, table is Sheet1);
LOAD ORG, COUNTRY , ORG&'-'& COUNTRY AS REDUCTIONFIELD
(ooxml, embedded labels, table is Sheet2);
I'd like to know (really) where this comes from: "In the Section table you have to kept only one Reduction Field". I've been using multiple data reduction fields for quite awhile. Section Access does not create circular references.
See these for more info: