Before executing the transformation from a terminal window, make sure that you have a new examination file to process, let's say exam3.txt
. Then follow these instructions:
C:pdi-ce>pan.bat /file:c:pdi_labsexaminations.ktr c: pdi_filesinputexam3.txt
/home/yourself/pdi-ce/pan.sh /file:/home/yourself/pdi_labs/ examinations.ktr c:/pdi_files/input/exam3.txt
exam3.txt
should be at the end of the file.You executed a transformation with Pan, the program that runs transformations from terminal windows. As part of the command, you specified the name of the transformation file and provided the name of the file to process, which was the only argument expected by the transformation. As a result, you got the same as if you had run the transformation from Spoon—a small file appended to the global file.
When you are designing transformations, you run them with Spoon; you don't use Pan. Pan is mainly used as part of batch processes, for example processes that run every night in a scheduled fashion.
Appendix B tells you all the details about using Pan.
Change the main transformation of the last tutorial so that the process_date
is saved with a full format, that is, including day of week (Monday, Tuesday, and so on), month in letters (January, February, and so on), and time.
Create a transformation to see for yourself the different formats for the number 99.55. Test the formats shown in the Numeric fields section and try some other options as well.
Suppose that you read a file where the first column is a numeric identifier: 1, 2, 3, and so on. You read the field as a Number
. Now you want to send the data back to a file. Despite being a number, this field is regular text to you because it is a code. How do you define the field in the Text output step (you may choose more than one option):
a. As a Number
. In the format, you put #
.
b. As a String
. In the format, you put #
.
c. As a String
. You leave the format blank.
3.149.234.188