Forum Discussion

Barcoda's avatar
Barcoda
Frequent Visitor
3 years ago

Parsing Email Body into usable data

Hello PQ/PBI Friends. First time poster, long time answer seaker & Power Query/BI infactuated.   I've imported my entire weather folder into Power Query successfully but can't seem to understand h...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Barcoda - you need to delete the "in", "let" and "source" steps and delete the extra #"Filtered Rows" reference.  Focus on applying the #"Split Column by Delimiter" step to the #"Filtered Rows".  The moment this is applied to a column named "Column1".  You need to select your column.

Barcoda's avatar
Barcoda
Frequent Visitor
3 years ago

Hello Anonymous ,

I'm confused by your instructon, "Focus on applying the #"Split Column by Delimiter" step to the #"Filtered Rows"." I think I omitted/ deleted the other lines correctly. Here's where I''m at presently.

Cheers,

Dean

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Barcoda - if you can provide a sample file it might be easier to show how this solution can be done.

     

    • Barcoda's avatar
      Barcoda
      Frequent Visitor
      3 years ago

      Hi Anonymous ,

      Is there an email address I can send it to? My work email is in the file and I'd rather not share that out here. If you can send me a mesage here with an email address I'll send you the file.

      Cheers,