Merging records from multiple data sets

Chez

Summary

Merging records from multiple data sets

Content

Hi All

I need some urgent assistance please. I have an xml file with the attached layout. This produced two records in my results as per attached. Refer results in excel file the first table.

The second table of results in the excel file is what I want my template to produce.

I also share the template with you.

What changes are required to be made to my template that will allow the data to be merged for these two records into one record? 

Thanks

Tam

User910243567

I would suggest to modify the source which is producing .xml file with the values the way you desire which would be much easier.

But if want to the output in the way you mentioned in .xlsx, You can try insert summary columns at the end using https://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T527073T558233.htm.

Then you can use conditional formatting to display only summary columns on your report. "That's is just my two cents"

Chez

Hi Suresh

Thank you for your response. I cannot change the source as it is seeded source so I have to try and find a way to get to records producing 1 record with values summed up. 

I am not following you on your first suggestion of 'try insert summary columns at the end using https://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T527073T558233.htm' ....  There is nothing in that link that indicates any information on how I would summarise values across two different groups of data? 

I do however understand what you mean by then using a conditional formation to display only summary columns.

Please assist in explaining exactly what you mean by your suggestion. I would be most grateful.

 

Thanks

Tam

User910243567

Can you try to recreate the report from group 'G_INV_CUST' instead of 'G_CUST_1'  as it's now in rtf.

You need to recreate your template, something like this..

<?for-each:G_INV_CUST?>

field1: <?SUM(TOTAL_CUST_AMT)?>

field2: <?SUM(TOTAL_CUST_B0)?>

....so on

<?end for-each?>

Thanks