Forum Discussion

Noxy's avatar
Noxy
Frequent Visitor
3 years ago

Unstructured data taking values from one record and combining those values with other records.

Hi all, Given records like these below AAA,time,00:00:11 AAA,date,07-JUL-2023 CPU_ALL,T0001,56.1,23.5,0.4,20.1,79.6,32 CPU_ALL,T0002,57.1,22.2,0.3,20.4,79.3,32 AAA,time,00:10:11 AAA,date,07-JU...
Need Help
SRHayward's avatar
SRHayward
New Member
2 years ago

Hi Noxy,

 

Did you manage to get this to work?  We have seen this before and developed a solution to import nmon data into PowerBI.  Please let me know if you would like to know more.

 

Stuart

Noxy's avatar
Noxy
Frequent Visitor
2 years ago

Hi Stuart, thanks for replying. Yes I'm all good now thank you. As I have progressed, I've actually ended up going back to the raw data and transforming / extracting what I need at that end which vastly speeds up the process. It was good to have a go at this to continue learning about PowerBI. Sadly I am addicted at the moment 🙂 Regards, Noxy

  • SRHayward's avatar
    SRHayward
    New Member
    2 years ago

    Hi Noxy,

     

    Great to hear that all is good now.  For your interest, here is a link to an article I published on Linkedin regarding nmon data:

     

    Long term nmon reporting 

     

    At the time of publishing this, I was using another tool to import nmon data and produce charts.  Power BI brings this data to life and, as you say, becomes rather addictive ğŸ™‚

     

    Stuart