I have designed a xsl file to transform the above xml and parse it using perl. Till now my script works fine because in side Tag3/stag1/ and Tag3/stag2, we always have 3 entries. For todays file we have some stag1 amd stag2 where we have only 2 entries or 1 entris. Which causes problem and my output file has wrong number of coloumns for those entries. Now I want to check each "F" value inside stag1 amd stag2 and map it to /tag2/subtag1 /subtag2 "F" values. For each non matching, It should have null value against those years.
I don't how can I map the "F" value in stag1 and stag2 with "F" subtag1/subtag2. Can any one please help me out?