Forum Discussion

PowerBIET's avatar
PowerBIET
Frequent Visitor
2 years ago
Solved

Scrape text into columns from Website

I need help to get Domestic and International Carriers with airlines into 2 different columns from this public website Passenger Airlines.  I am using the Web data source connector.  PBIX Link  ...
Need Help
Tutorial Requests
  • Martin_D's avatar
    Martin_D
    2 years ago

    Technically, a solution woulde be:

    1. Create a query loading the red list into a table with one column
    2. Create another query loading the green list into a table with one column
    3. In each of the two tables add an index column
    4. Join both tables on the index column using full outer join https://learn.microsoft.com/en-us/power-query/merge-queries-overview 
Martin_D's avatar
Martin_D
Solution Sage
2 years ago

Technically, a solution woulde be:

  1. Create a query loading the red list into a table with one column
  2. Create another query loading the green list into a table with one column
  3. In each of the two tables add an index column
  4. Join both tables on the index column using full outer join https://learn.microsoft.com/en-us/power-query/merge-queries-overview