Reply
Frequent Visitor
Posts: 4
Registered: ‎06-16-2016
Accepted Solution

Lab 1 - Question 3

Last step 

  • Set the Data Type of both the Year and Population columns to Whole Number."

Do you really want us to change Data type of Date column with Whole Number?

If I am doing that I am geting "36526" these kind of numbers. 

 

Is this right?

 

Thanks,

Dhwani


Accepted Solutions
Established Member
Posts: 137
Registered: ‎11-28-2015

Re: Lab 1 - Question 3

You don't need to count the rows manually, the value is displayed on the bottom left in the data pane. Take a look at the screenshot below.

 

DataRows.PNG

If this answers your question, please mark as answered and give kudos.

 

Thanks,
Sam Lester (MSFT) 

View solution in original post


All Replies
Established Member
Posts: 137
Registered: ‎11-28-2015

Re: Lab 1 - Question 3

[ Edited ]

Yes, thses are what the instructions want you to do. It is a bit contrived, but the whole number values are not required to answer the homework questions for this lab.

 

Thanks,
Sam Lester (MSFT)

Frequent Visitor
Posts: 4
Registered: ‎06-16-2016

Re: Lab 1 - Question 3

Yes .. I did as per instructions and I counted the rows manually to answer the Lab Question. 

 

Is that the right way to do it? 

Established Member
Posts: 137
Registered: ‎11-28-2015

Re: Lab 1 - Question 3

You don't need to count the rows manually, the value is displayed on the bottom left in the data pane. Take a look at the screenshot below.

 

DataRows.PNG

If this answers your question, please mark as answered and give kudos.

 

Thanks,
Sam Lester (MSFT) 

Frequent Visitor
Posts: 4
Registered: ‎02-06-2017

Re: Lab 1 - Question 3

How do i know  How many distinct values of the Year column were imported from the Country Population query?, please help