Writing data to DB with Multiple CDT

can you provide the screenshot of your DB node configuration ?

please make sure that value at each index of that array have different IDs.

@shrutis Are you trying to perform only insert operation or Insert/Update operation, because in case of update operation, if the Primary Key value matches for more than one row then previous will be be override by the new row

@aloks176 thanks for a better explanation.

it seems that you are trying to append single value in multiple CDT in Data tab > "output" of script task/ user input task
make sure you have selected operator "is appended to" rather then default "is stored as"

You can try configuring the write to db node as a MNI node, if as per my understanding, you want all the cdt entries with unique ids in the data store.

thank you everyone for your suggestions, tried generating unique ids and saving records with IDs it helped.

@shrutis happy to hear that, but it seems like you are trying to perform insert operation, if i am not wrong. So if you are using Autogeneration for ID then i don't think that you need to generate unique Id's by manual process such as script task etc.. in this case the DB or JPA will take care of generating Unique ID's