Free Preparation Discussions
MENU
Microsoft PL-600 Exam - Topic 8 Question 26 Discussion
Topic #: 8
A company sells antique books. The company stores data about book locations in an existing system by using the following database fields: Room, Shelf.
The company must import the data from the existing system into a Power Platform solution. Existing data into must be modified to match the design of the new solution.
You need to recommend a solution to combine the room and shelf fields into a single column during the import process.
Which tool should you recommend?
Dataverse includes a web application tool called Import Data Wizard. You use this tool to import data records from one or more comma-separated values (.csv), XML Spreadsheet 2003 (.xml), or text files.
Use transformation mapping to modify data before importing it. For example, split a full name that is contained
in the source file into a first name and a last name to match the target columns for a table.
Note:
To implement data import, you typically do the following:
Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file.
Create a data map or use an existing data map.
Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file.
Create a data map or use an existing data map.
Associate an import file with a data map.
Upload the content from a source file to the associated import file.
Parse the import file.
Transform the parsed data.
Upload the transformed data into the target Dataverse server.
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/import-data
Shayne
4 months agoTiffiny
4 months agoIsaac
5 months agoJimmie
5 months agoKanisha
5 months agoLauna
5 months agoGilma
5 months agoJaney
5 months agoValentin
5 months agoSheldon
5 months agoAntonio
5 months agoJenelle
5 months agoBong
6 months ago