Welcome and thank you for joining our new OpenText forum. Your questions, responses, best practices, and tips shared with other members will help make this channel vibrant. We're glad you're joining us and look forward to collaborating with you online.

Check out the Getting Started With OpenText Forums for tips on personalizing your experience.

Best practice to display first and last entry from a CSV data set

I will be creating 50+ reports from a few CSV files which will be similar in nature. Most of the reports will have a line or bar chart and would need to display the first and last day that data is available (which of course changes). I have gotten that working by defining two lists, assigning a group to them and in the group using “Bottom n” and “Top n” operators in a filter with the value of 1. Is there a better way to do that?


 


The easiest way that I have found to replicate that has been manually copying the lines for the lists from the xml file of an existing report and pasting them in the xml file of the new report before the <table>…</table>. Is there a better way to do that?


Comments

  • edited January 13, 2017

    Hi mmr1148,


     


    your solution is very good and BTW very easy.


    Another easy solution is to create 3 computed column


    1) name : row - type ; integer - Expression : 1


    2) name : runningcount - type ; integer - Expression : runningcount(row["row"])


    3) name : rowount - type ; integer - Expression : sum(row["row"])


    and a filter


    Expression row["runingcount"] == row["rowcount"] || row["runingcount"] == 1 - isTrue


     


    Example join


    Guillaume L.
    Solution Consultant
    OpenText Reporting & Analytics
    http://www.opentext.com
Sign In or Register to comment.