Assigning values to individual fields within a 'Record' variable

Hi,

I created a variable of type ‘Record’ and set the schema i.e. defined the fields in it.

I have about a dozen fields like PurchaseOrder, ItemNumber, Qty etc.

Now I need to assign values to the individual fields in the Record Variable. The are are multiple sources where the values can come from like 5 fields coming from a DB table and  remaining needs to be hardcoded.  Once all fields in the Record variable are populated with a value the eventual goal is to add the record to a table.

When i use the Assign action of Record package I can only move data from one Record to another Record variable as a complete set but it doesn’t allow to set values to individual fields. If i use the Assign action of String package then then the destination needs to be a String type variable.

Has anyone faced a similar challenge. Appreciate if they can share their experience and a possible solution/workaround.

Thanks,

Srini