You have a filtered dataset for Customer Sales with some null value rows. You want to remove these rows completely. How will you do this

Question

Cowlan667 Cowlan667

01-04-2022
Computers and Technology

contestada

You have a filtered dataset for Customer Sales with some null value rows. You want to remove these rows completely. How will you do this

Respuesta :

Otras preguntas

Solve y over negative 6 + 5 = 9.

what are the possible values of x if (4x – 5)2 = 49? check all that apply. -4/5 -1/2 3 5 7

Triangle ABC is an isosceles triangle in which AB = AC. What is the perimeter of △ABC? 5 + square root of 10 units 3x square root of units 10 + square root of

Which vascular tissue is involved in the transport of starch found in fruit pulp?

what is the density of an object that has a mass of 550 grams and displaces 25 ml of water? select all that apply. 22 ml/g .04 ml/g 22 g/ml 22 g/cm 3

a student has written a journal. which of the following is true? a journal is the same as a personal narrative. a journal is often personal, not public. a commu

What term describes the people of the Ghana Empire? A. Muslim B. Animists C. Isolated D. unskilled I FOUND THE ANSWER the answer is B. Animists!! thank you anyw

Why would it be hard to find the ideal CO2 level if the light intensity were very low?

A historian claims that the boxer rebellion should be blamed entirely on the chinese people as the boxer movement was started by chinese. Which of the following

A student standing on the ground next to a tall building throws a ball straight up with a speed of 39.2 m/s. If it takes the ball 4 seconds to reach the same he

Martebi Martebi · Answer 1 · 2022-04-08T10:15:14+02:00

The option is to Deselect (blank) in the pull-down menu for Customer Sales in the dataset.

How do one delete these rows completely?

If a person is working in the Query Editor (that is the place where one can get data, before you close and apply).

The right thing to do is to select the column that you want to use to check for nulls and when the values you are looking at is really blank, you can then click the drop-down and delete Rows in the ribbon, then one can click the option of Remove Blank Rows.

See full options below

Select an answer:

Deselect (null) in the pull-down menu for Customer Sales in the Power Query Editor.

Deselect (blank) in the pull-down menu for Customer Sales in the dataset.

Change the filter so null value rows are not displayed.

Place your cursor to the left of the rows, and then select Delete.

Learn more about dataset from

https://brainly.com/question/24309209