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?
Discussion posts and replies are publicly visible
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?
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 .
Hi iswarya2812 ,
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.