Forum Discussion

Mehay's avatar
Mehay
Helper I
4 years ago
Solved

Create region

Dears,    I'm trying to create a region column with existing list of countries, what would be the best and fast way of it?  so i have all countries but need to identify its regions, like Europe, A...
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Mehay I think you should have html tables there available by the way this website looks. Not in front of PC, so can't make sure. There is also the tables by example feature in the web connector that you can use to extract the tables. It's a good practice. Mayve try a different website.

    BTW, Instead of connecting to a static excel you can also just copy paste the table from excel to the 'enter data' option directly in the grid view and continue editing in PQ. 

    P.S. don't forget to mark my messages as solutions for community visability and appreciate your kudos 🙂