In Astera, you can export the extracted data to various destinations such as Excel workbooks and files, or a database table destination such as SQL Server, PostgreSQL, MySQL, ODBC, etc.

Follow the steps mentioned below to export your Report Model to a dataflow:

When you expand the rules for filtering data, you will see the following three sections:

• Functions - an extensive library of built-in functions from where you can select any function according to your requirement and apply it to your data

• Objects Panel - it contains the layout of your report model from where you can simply double-click on the object and write it in your function

• Expression builder - here you can write your expressions by either selecting it from the built-in functions library or writing one of your own

2. Write expression ITEM= “SOFA” in the expression builder. Compile your expression to check if it is successful or not and click OK when the compile status is successful.

3. Go to the Model Layout panel where you can see your exported file with multiple export setting options such as:

   • Preview Selected Export

   • Edit Export Settings

   • Run Selected Export

5. Click on destination file link to open the output file. You can see that only filtered items have been exported to the destination file.