Forum Discussion

anupambit1797's avatar
anupambit1797
Steel Contributor
Dec 01, 2023
Solved

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...
BI & Data Analysis
power bi
anupambit1797's avatar
anupambit1797
Steel 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'?

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

      Hi anupambit1797 

       

      Attached is '1980 Jan 12 04:29:42.758 [D8] 0xB132 LTE LL1 PDSCH Decoding Results' from the CSV you initially shared

       

      In the Expected_Result you posted (I don't undersand why you did not use my file...) - just the first 2:

      Could you tell me where you find Frame = 828 and Frame = 832 in the attachment ???

      • anupambit1797's avatar
        anupambit1797
        Steel Contributor
        Dec 08, 2023

        HiLorenzo , the one I attached is from the whole dump file, to give an example on how the expected result should look like,

         

        Br,

        Anupam

Resources