Forum Discussion
anupambit1797
Dec 01, 2023Iron Contributor
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...
- Dec 19, 2023
I just realized I forgot to push you the query the other day 😞
Lorenzo
Dec 08, 2023Silver Contributor
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'?
anupambit1797
Dec 08, 2023Iron Contributor
HiLorenzo , I updated the Title as per your recommendation , and attached the expected excel.
Br,
Anupam
- LorenzoDec 08, 2023Silver Contributor
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 ???
- anupambit1797Dec 08, 2023Iron Contributor
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
- LorenzoDec 08, 2023Silver Contributor
OK but that's not what I asked & need
I asked - to make sure what I'm working on meets your expectations - that you provide me the expected result for '1980 Jan 12 04:29:42.758 [D8] 0xB132 LTE LL1 PDSCH Decoding Results' in the workbook I earlier shared
If it's too much asking forget and we'll leave it there, no problem