Data Mapper Table rows extraction

1

I have csv file where I have mentioned 3 types columns like name_1, id_1,amt_1
, same way name_2,id_2,amt_2, it goes till _30. All column are part of single row. that row has other data as well but this type of data I want to put all 3 type in table format, so basically 30 tables with 3 row and column should be set up in datamapper.
How can I achieve this.

2

Hi @djinkal,

Do you have an anonymized data file which I can try to help you with the rows extraction? I can try to help.

3

You can create a Detail Table through the Data Model GUI panel. Then extract your columns. In the Step Details GUI panel for the extracted field(s), you can:

  • change the Table from the master “record” table to your Detail table and
  • rename the extracted field to have the same name as the other extracted fields so that it creates a new detail record
4

Hi @djinkal,
I have uploaded a sample datamapper which I have tried to use the structure you have mentioned but you might need to update it to suite your data file structure. This way is a bit complex and you have to manage the extraction yourself.

@TGREER, I think this is what is being asked but I could be wrong!

sample.OL-datamapper (5.2 KB)

5

We got the solution after contacting Support via raising ticket.
Thank you for your response.