Procedure
- Double-click tFileInputDelimited to open its Basic settings view.
- In the File name/Stream field, enter the file path between double quotes.
-
In this example, the input data is:
id;price1;discount1;price2;discount2 1;100;0.2;2000;0.1 2;1000;0.05;4000;0.2 3;1999;0.15;4200;0.2 4;5000;0.2;3000;0.2 5;300;0;30;0 6;6000;0.2;3000;0.1 7;price;;;
- Select Built-In as Schema and click […] next to Edit schema.
-
To add columns, click and click OK.
Dynamic schema retrieves the columns which are undefined in the schema. That is why you do not need to define the discount1, price2, discount2 columns in the schema.
Important: You can use a dynamic schema in the Standard component. Apache Spark components do not support it.