11-03-2010, 12:15 PM
Well I want to know how to read the values in hierarchy.
1) If Program element is the parent with TMSID attribute, image is grand child which may or may not exist for each program element. (Program/images/image is the hierarchy) And if exists there may be multiple occurrences also.
When there are multiple occurrences excel should get a row for a program's TMSID, each Image category attribute& URI text value combination
2) URI element is the child of image whose text value I want to get for program TMSID attribute.
1) If Program element is the parent with TMSID attribute, image is grand child which may or may not exist for each program element. (Program/images/image is the hierarchy) And if exists there may be multiple occurrences also.
When there are multiple occurrences excel should get a row for a program's TMSID, each Image category attribute& URI text value combination
2) URI element is the child of image whose text value I want to get for program TMSID attribute.