mapping tabular data to entity-attribute-value model

Ehrlich, Joel

• November 17, 2021 20:41

I want to take a source file, say Excel, with a count of N rows and M columns, and convert it into a three column map=> rownumber, column name, cell value.  For example, consider a table of 10 rows and 20 columns, the revised structure would be 3 columns, 200 rows, one row for every cell in the table.  How might I do this in the data mapper?

-1

• 

  Siddhant Tyagi

  • November 29, 2021 12:03

  Joel,

  Please follow the following steps in the Data Mapper for mapping tabular data to the entity-attribute-value model. Excel schemas at both source and target ends have been used and their structure can be seen in the provided screenshots.

   

  Step 1:  Apply ForEach as shown below on the record node.

   

  

   

  Step 2: Apply the textual condition on the rowno node.

   

  

   

  Step 3: Apply the textual condition on the colname node to print the column names of the source file.

   

  

   

   

  Step 4: Apply the textual condition on the dataval node.

   

  

   

   

   

   

   

   

   

   

  0

Post is closed for comments.