Mark Data Blocks

Why Block Transformation Was Created

Block Transformation simplifies the process of converting complex Excel files into a more suitable format for data processing. This ensures that even challenging layouts can be processed efficiently.

Example of a Complex Excel File

Users can mark data blocks within an Excel file, apply transformations step by step, and save the results into a structured Excel format.

Marking Data Blocks

Key Features:

Select specific cells, columns, rows, entire sheets, or groups of cells.
Handle multiple Excel files and data blocks simultaneously.

Note: The flexibility to define blocks makes it easy to process diverse data layouts.

Transforming Data Blocks Using Steps

Click the plus button to add a new block transformation step.

Tip: Each step can be configured to handle a specific part of the data transformation, ensuring a modular and logical process.

Executing Block Transformation

Press the green arrow to execute the block transformation. The steps are processed sequentially from left to right.

Video Tutorial

For a comprehensive walkthrough of Block Transformation, refer to the video tutorial available on the platform. This video demonstrates marking data blocks, setting up transformation steps, and executing the process efficiently.