![]() ![]() ![]() In the right panel, select 'is greater than' from the first drop-down list and then select '21.0' from the second drop-down listī.) From the Column to Filter list, select Age. When you import data, after selecting all the columns from the table using the query wizard (Data(tab) -> Get External Data (group) -> From Other Sources -> From Microsoft Query), how will you filter the records to retrieve those that has a value greater than 21 for 'Age' column.Ī.) From the Column to Filter list, select Age. The workbook has a table called 'Employee'. ![]() ![]() Please use the attached workbook as an external data source. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |