Forum Discussion
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
Technically, a solution woulde be:
- Create a query loading the red list into a table with one column
- Create another query loading the green list into a table with one column
- In each of the two tables add an index column
- Join both tables on the index column using full outer join https://learn.microsoft.com/en-us/power-query/merge-queries-overview
2 Replies
Technically, a solution woulde be:
- Create a query loading the red list into a table with one column
- Create another query loading the green list into a table with one column
- In each of the two tables add an index column
- Join both tables on the index column using full outer join https://learn.microsoft.com/en-us/power-query/merge-queries-overview
Here are the steps that you can follow:
Create a query loading the red list into a table with one column.
Create another query loading the green list into a table with one column.
In each of the two tables, add an index column.
Join both tables on the index column using a full outer join.
