This content has been marked as final. Show 3 replies
Follow these steps:
- transpose load the first 3 rows (as colummns) using a fill down for the blanks
- create a name mapping table to map column letters to concatenated names from the header rows
- load the data without headers
- Rename the fields using the map
See attached for an example using your sample.
Hierarchy.qvw 138.5 K