"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 source file (it can be a fragment of the real file or the whole file unless it contains 500 lines). Then, you can continue building a transformation with other nodes that let you add, merge, and rename columns, edit values in the rows, and so on. The transformation made on this sample file will help you see the results of the transformation made on the actual file. Data from the sample file is not passed to a workflow itself.
The node contains the preview of the data in the file and their presentation depends on the file type.
The preview of the transformed file is available in the Data Output node, which is always the closing component of the transformation workflow.
After the transformation is saved and published, it can be used in further processes, such as imports, as a set of rules for the actual file to be transformed.
- The file can contain up to 500 rows
- The allowed file formats:
name,surname,email_address Dwight,Addams,email@example.com Martin,Smith,firstname.lastname@example.org Kurt,Doe,email@example.com
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
- Upload the file or drag it onto the specified area on the pop-up.
- 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 the first 10 rows of the file.
- Confirm by clicking Generate.