Creating schemas from lists
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.
Getting ready
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.
How to do it...
Select all the column names from the word document and paste into an Excel spreadsheet:
Now select all the fields, right click it, and select Copy.
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.csvYou can then import the CSV file using the wizard for
Filedelimitedand stating that the file has a heading row.
Set the field separator as Comma, and tick the box...
