Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Dec 01, 2023

Power Query/PowerBI Extract some values from complex CSV

Dear Experts,

                  From attached file, I need to create a Report like below:-

Each of the Report entry has following parameters:-

So from "TB Top " we need to extract "Frame" & "SubFN" ; from "TB Config" we need "CW Index"

and from the "CB" we need "CRC"

 

 

Thanks in Advance,

Br,

Anupam

 

BI & Data Analysis
Power BI
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Dec 07, 2023

    Hi anupambit1797 

     

    (Not a specifically a 'Power BI Topic')

     

    I looked at your case. IMHO, as it is, it's above the scope of a forum/community (my view only). Getting the expected result (not cleary defined yet) requires:

     

    #1 Analysis of the stucture of records of say 3-5 IDs (between 2 '1980 Jan 12 wxyz LTE LL1 PDSCH Decoding Results')
    #2 For IDs where > 1 CRC values exist, do you report the 1st, the last, the min, the max..., all?
    #3 Manually or via formula do the job on say 3 different & representative IDs to allow checking the query output
    #4 Build the corresponding query (sounds doable but not trivial)

     

    If you provide #1-3 (accurate) in an Excel workbook, I can take a look at #4

    Hope this helps & makes sense

    • anupambit1797's avatar
      anupambit1797
      Iron Contributor
      Dec 07, 2023

      HiLorenzo ,

      Comments inline

       

      #1 Analysis of the structure of records of say 3-5 IDs (between 2 '1980 Jan 12 wxyz LTE LL1 PDSCH Decoding Results')

      [Anupam] Answered in 2
      #2 For IDs where > 1 CRC values exist, do you report the 1st, the last, the min, the max..., all?

      [Anupam] CRC supported values are only "0" or "1", and need to report all the CRCs( 0,1) for each of the records.

      Algo should be like => Each Record has a Unique value of "Frame , SubFN",

      So , From each record:-

      We need :-

      Frame, SubFN => from TB Top

      CW Index => from TB Config

      and CRC => from CB


      #3 Manually or via formula do the job on say 3 different & representative IDs to allow checking the query output

      [Anupam] Attaching a sheet(Sheet_3) doing manually for 3 records below:-

      1980 Jan 12 04:29:31.203 [76] 0xB132 LTE LL1 PDSCH Decoding Results

      1980 Jan 12 04:29:31.286 [BB] 0xB132 LTE LL1 PDSCH Decoding Results

      1980 Jan 12 04:29:31.527 [1A] 0xB132 LTE LL1 PDSCH Decoding Results

       

      Thanks in Advance,

      Br,

      Anupam

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Dec 08, 2023

        Hi anupambit1797 

         

        Could you revise the title of this thread to help people who Search please?

        i.e. 'Power Query/PowerBI Extract some values from complex CSV'

         

        Re. #1 and #2 I was more looking at something like:

        to help me work on #4. Done in attached file based on 3 different UIDs

         

        To ensure we're on the same page, while I work on #4, could you please provide the expected result for '1980 Jan 12 04:29:42.758 [D8] 0xB132 LTE LL1 PDSCH Decoding Results' (table prepared in attached file, sheet 'Expected Result'?

Resources