# Report Source

Report Model extracts data from an unstructured file into a structured file format using an extraction logic. It can be used through the *Report Source* object inside dataflows in order to leverage the advanced transformation features in Astera Data Stack.

### Video

{% embed url="<https://www.youtube.com/watch?v=55xGbf3y_BE>" %}

### Getting Report Source Object

In this section, we will cover how to get the *Report Source* object onto the dataflow designer from the Toolbox.

1. To get a *Report Source* object from the Toolbox, go to *Toolbox > Sources > Report Source.* If you are unable to see the Toolbox, go to *View > Toolbox* or press Ctrl + Alt + X.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FPdmdNfSyWAgiJTmAPWOr%2F1_toolbox.png?alt=media\&token=091d6490-8107-4bd6-9394-43dea6609263)

2. Drag-and-drop the *Report Source* object onto the designer.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F2pXpbUwhP8GVicwU3bGd%2Freport_source_gif.gif?alt=media\&token=3d1d48e9-05f4-4c7f-935a-529aef86dbd1)

You can see that the dragged source object is empty right now. This is because we have not configured the object yet.

### Configuring the Report Source Object

1. To configure the *Report Source* object, right-click on its header and select *Properties* from the context menu.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FCNsfv2LVjkxDvFeCWSXs%2F2_prperties.png?alt=media\&token=7c00d8b1-f001-4ad7-af45-200c8cff5077)

A configuration window for *Report Source* will open.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FA53GoxfUYRpGWd8KBXSW%2F3_config.PNG?alt=media\&token=18de027a-913b-4a44-8419-c517338b97b6)

2. First, provide the *File Path* of the unstructured file (your report) for which you have created a Report Model.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FAuKZGutsquyHNyMwideN%2F4_file_path.png?alt=media\&token=fb6d34bf-321c-4686-ab03-544219b8a4a1)

3. Then, specify the *File Path* for the associated Report Model.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F5rYDwGgCy8fQLi0ZrkYT%2F5_model.png?alt=media\&token=22352399-a6a4-421b-a2c3-dd7b5f9b5b0f)

4. Click *OK*, and the fields added in the extraction model will appear inside the *Report Source* object with a sub-node, *Items\_Info*, in our case.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FX9i5JkVUuoiuLjAEEIbF%2F6_object.PNG?alt=media\&token=300f05a7-868e-4b8a-a5ab-0919c194ed5e)

5. Right-click on the *Report Source* object’s header and select *Preview Output* from the context menu.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FklOGEacEVbw60WM8bAYK%2F7_output.png?alt=media\&token=9b55dad5-ff56-4ce1-bf89-3485e4847ac9)

A *Data Preview* window will open and shows you the data extracted through the Report Model.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FdzTz14yhVflfCVuHPMpg%2F8_data.PNG?alt=media\&token=1f4d35dd-f780-456d-a3d2-241cf3b27d72)