This next recipe doesn’t make use of Talend at all. Rather, it is a technique to save lots of tedious typing when creating schemas from documents and/or spreadsheets.
Open the MS Word document customerFieldList.docx
. As you can see, there are a reasonable number of field descriptions that would take a reasonable amount of time to define individually.
Select all the column names from the word document and paste into an Excel spreadsheet:
Go to the second worksheet and click the top-left cell.
Then, right-click and select Paste Special, and select the option Transpose:
This will copy the previous vertical list into a horizontal list.
Delete the initial worksheet and save the file as a CSV file named
TransposedCustomer.csv
You can then import the CSV file using the wizard for
File
delimited
and stating that the file has a heading row.Set the field separator as Comma, and tick the box...