Forum Discussion
Power Query/PowerBI Extract some values from complex CSV
- Dec 19, 2023
I just realized I forgot to push you the query the other day 😞
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 ???
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
- anupambit1797Dec 08, 2023Iron Contributor
HiLorenzo , I tried to do the same manually for the Record you mentioned , for ~6 Records, Expected result in Attached "Anupam_Expectation"sheet. Used a Unique Identifier "CB Index" CB-> # and TB Records
Thanks in Advance,
Br,
Anupam
- LorenzoDec 19, 2023Silver Contributor
I just realized I forgot to push you the query the other day 😞