How to auto-populate field types when creating a data model using a spreadsheet from App Studio.

Hello,

We are trying to create a new data object from App Studio in Pega Infinity '24.1
1)App studio > Data > New
2) I’m using the “Create Data Model using spreadsheet” option to import my data model

3)Upload CSV/XLXS file(This file contains column headers that represent field names, and each field type is defined)
4) The next screen displays the list of fields defined in the file; however, the field type for all the defined fields is listed as TEXT type.

Activity - "pzPrepareDataModelMappingFields" is invoked in the backend and it is used to read the CSV or XLSX headers and first-row values and prepare the fields and their data types

Does anyone know how can I auto-populate field types from the uploaded file?

I’ve attached all the useful images and xlsx file. Please check them

Customer_B.xlsx (8.96 KB)

@Sanath kumar P

You need to upload the excel with sample data with correct format.

Customer_B.xlsx (11.3 KB)