Transform Map: Insert multiple records from single source record

[Lohith]

I have an CSV file which has a field that contains a comma separated list of items. I need to create a record in the target table for each item listed in the comma separated list.

For example, a source record may look like this:
Field1: Hyundai
Field2: Verna, I20, Creta

The result in the target table should have a record for each of Field2:
Record1: Field1=Hyundai Field2=Verna
Record2: Field1=Hyundai Field2=I20
Record3: Field1=Hyundai Field2=Creta

Any inputs will be much appreciated.

Thanks

[RAHUL Khanna1]

is it possible for you to copy and format that in excel and then upload ....or else we need to observe in what format the data is in CSV file. can you provide the snapshot of the CSV file ...

[Lohith]

No, we cannot format in Excel file, that is scheduled import.

We have 2 fields in CSV file, both are string type fields in Target table.

Field2 contains comma separated values.

For example, a source record may look like this:
Field1: Hyundai
Field2: Verna, I20, Creta

The result in the target table should have a record for each of Field2:
Record1: Field1=Hyundai Field2=Verna
Record2: Field1=Hyundai Field2=I20
Record3: Field1=Hyundai Field2=Creta

[SaiRaviKiran Ak]

Hi,

Prepare your file with 3 rows of data as mentioned in the below screenshot.

After preparing your file,load the data into instance and run the transform map by selecting source table and target table.

Note : Make sure that your field names and target table field names (back end names) should match to reflect changes.

Mark Correct if it solves your issue.

Thanks,

SaiRavikiran Akella

[Lohith]

I cannot prepare file, since its a scheduled import. will fetch CSV file from path given in data source and executes it.