Empty RITM creation when creating bulk ritms through transform map

[MercBuilding]

Hi,

  Iam trying to create multiple ritms under single request using excel file and flow designer. For this i have created Data source with excel file, scheduled import and a onComplete transform map script to create multiple RITM's under single request. For this i have used flow designer to create data source record and scheduled import to run the transform and create multiple RITM's. Below is teh screenshot of flow designer logic.

It is creating multiple ritms based on excel file but it is creating an orphan record without Request number and Item. I have given ignore=true in my transform map script as well but still it is creating an orphan record. Can someone tell me what i need to change to avoid creation of this orphan request.

Thanks!!

[Brad Warman]

Check the excel file for a blank space or some other character in the row after the last record. It's likely picking up a 'blank' row as a record and including that in the import. You could also try to convert the excel file to a CSV and ensure that only the relevant records are configured between the commas.

[MercBuilding]

Hi @Brad Warman ,

  It is not picking up any empty row because atleast it should populate the request number or item name if it is creating through transform map. The details are empty as shown in the screenshot.