Skip to main content
iswaryan3555
iswaryan3555
December 9, 2024
Question

I need to insert data from interface to data store entity

  • December 9, 2024
  • 3 replies
  • 0 views

I am inserting excel data to data base using write to data store entity smart service  .  I need to inset two more fileds of data which is user inuput data which will be entered when uploading the excel  through the write to data store entity  .  I don't know how to acheive it. Can anyone help me?

3 replies

stefanhelzle0001
stefanhelzle0001
December 9, 2024

I am not 100% sure I understand what you are doing. Did you consider to write the data in two steps? First, the Excel, and the other data later on?

iswaryan3555
iswaryan3555Author
December 9, 2024

I need to insert a form data which will have excel and user data into a staging table. For that I am using write to data store smart service.  I didn't tried with two steps. I have confusion for the data type of user input inside the smart  service. In the interface the datatype is number and for another its text.  But when using the smart service what should i give? i tried with same text , integer and also the type of data store entity. But I couldn't achieve it .

jayaprakashr0001
jayaprakashr0001
December 10, 2024

Hi [mention:24ecc13e300c47b1a73ada75867e8d92:e9ed411860ed4f2ba0265705b8793d05] ,

first you can extract the data from excel sheet and have it in the grid with the two extra fields . Once after entering the details based on button Action you can use the smart service to write to the database.

Terms & ConditionsAccessibility statement