Reply
Highlighted
Frequent Visitor
Posts: 2
Registered: ‎02-01-2016
Accepted Solution

lab 1 - q3

Dear all,

I have tried many times the steps of the lab 1 - exercise 3 and the results is:


How many rows were imported from the Country Population query? 5


How many distinct values of the Year column were imported from the Country Population query? 1

... but I got the wrong result ...

Wuold you mind to explain me my mistakes? ... and why?


Best regards

sl


Accepted Solutions
Frequent Visitor
Posts: 5
Registered: ‎01-31-2016

Re: lab 1 - q3

Hello sir.

it is possible that you forgot to "un-piviot" the Country and Population data &colonSmiley Wink.

since the origional file has only 5 rows but spread out over 17 columns

(looking somthing like this on initial import)

Population initial import.jpg

it sounds like you were able to remove the first 4 rows and promote the headders just fine.

but perhaps forgot to run the unpiviot function. below are the steps:

 

  1. Select the "Country" column
  2. go to the "Transform" tab in the ribbon
  3. select the dropdown chevron beside the "unpiviot" option.
  4. choose to unpiviot OTHER columns

should look like this:

Population unPiviot step.jpg

you should endup with a very narrow and long table with the countries repeated with the years and values as row entries like this:

Population final state.jpg

 

Hope this helps.

let me know if you need more.

Cheers.

Ct

View solution in original post


All Replies
Frequent Visitor
Posts: 5
Registered: ‎01-31-2016

Re: lab 1 - q3

Hello sir.

it is possible that you forgot to "un-piviot" the Country and Population data &colonSmiley Wink.

since the origional file has only 5 rows but spread out over 17 columns

(looking somthing like this on initial import)

Population initial import.jpg

it sounds like you were able to remove the first 4 rows and promote the headders just fine.

but perhaps forgot to run the unpiviot function. below are the steps:

 

  1. Select the "Country" column
  2. go to the "Transform" tab in the ribbon
  3. select the dropdown chevron beside the "unpiviot" option.
  4. choose to unpiviot OTHER columns

should look like this:

Population unPiviot step.jpg

you should endup with a very narrow and long table with the countries repeated with the years and values as row entries like this:

Population final state.jpg

 

Hope this helps.

let me know if you need more.

Cheers.

Ct

Frequent Visitor
Posts: 2
Registered: ‎02-01-2016

Re: lab 1 - q3

Dear Nillock

thank you so much!

you are very kind...

 

best regards

saverio

 

 

Frequent Visitor
Posts: 2
Registered: Sunday

Re: lab 1 - q3

Hello,

 

I have followed every step, which including  "Unpivot Other Columnsand "Filter out the year 1999". 

Lab1Q3.jpg

5 rows were imported, but asnwer shows as wrong, please assist me where went wrong.

 

Thanks.

Member
Posts: 106
Registered: ‎03-10-2016

Re: lab 1 - q3

Filter out the year 1999,it means that you need to remove the data about 1999 or before, so you should only see data after year 2000.

Frequent Visitor
Posts: 2
Registered: Sunday

Re: lab 1 - q3

Thank you for the clarification, i have corrected it and got expected results.