Skip to main content Skip to complementary content

Configuring the tFileInputDelimited component

Procedure

  1. Double-click tFileInputDelimited to open its Basic settings view.
  2. In the File name/Stream field, enter the file path between double quotes.
  3. 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;;;
  4. Select Built-In as Schema and click […] next to Edit schema.
  5. 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.

    Information noteImportant: You can use a dynamic schema in the Standard component. Apache Spark components do not support it.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here