Data Input node

The Data Input node is the first node to be used while building a transformation. In the configuration of the node, you upload a sample file that imitates a structure of the final file. Then, you can perform operations such as adding a column, merging columns, renaming colums, editing values in the rows. The preview of the transformed file is available in the Data Output node, which is always the closing component of the transformation diagram.

After the transformation is completed, it can be used in further processes, such as imports, as a set of rules for a final file to be transformed.

File requirements

  • The size of the file cannot exceed 5 MB
  • The allowed file formats: .csv, .xml, .json

Example files

Customer data

name,surname,email_address
Dwight,Addams,dwight.addams@test.com
Martin,Smith,martin.smith@test.com
Kurt,Doe,kurt.doe@test.com

Transactions

customId,orderId,paymentInfo,finalUnitPriceAmount,productQuantity,sku,eventTimestamp,productName,productPriceAmount
123345,448362,cash,13.35,1,642,13.02.2022,shoe1,13.35
123345,448362,cash,40,1,453,13.02.2022,shoe2,40
345678,45678990,online,13.99,1,726,13.02.2022,shoe3,13.99

Node configuration


  1. Click Add example.
  2. Upload the file or drag it onto the specified area on the pop-up.
  3. Verify the values Delimiter, Quotation mark, and Escape character fields - they describe separators in the file you uploaded. You can use the Preview option to see how columns are organized in the file.
    Configuration of the Data Input node
    Configuration of the Data Input node
  4. Confirm by clicking Generate.
😕

We are sorry to hear that

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

😉

Awesome!

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

Close modal icon Placeholder alt for modal to satisfy link checker