Skip to main content

Financial report parser

This flow demonstrates how to parse LLM responses into a structured format.

In this example, the Chat Input component is pre-loaded with a sample financial report to demonstrate extracting Gross Profit, EBITDA, and Net Income. The Structured output component is used to extract the financial data from the report, and the Parser component is used to convert the extracted data into a structured format.

Prerequisites​

Create the financial report parser flow​

  1. From the Langflow dashboard, click New Flow.
  2. Select Financial Report Parser.

The Financial Report Parser flow is created.

Financial report parser flow

Run the financial report parser flow​

  1. Add your OpenAI API key to the Language model model component. Optionally, create a global variable for the OpenAI API key.

    1. In the OpenAI API Key field, click Globe, and then click Add New Variable.
    2. In the Variable Name field, enter openai_api_key.
    3. In the Value field, paste your OpenAI API Key (sk-...).
    4. Click Save Variable.

  2. To run the flow, click  Playground, and then click Send. The Chat Input component is pre-loaded with a sample financial report for demonstration purposes. The Playground returns a structured response:


_10
EBITDA: $900 million , Net Income: $500 million , GROSS_PROFIT: $1.2 billion

Inspect the flow to understand how this information was extracted.

  1. To inspect the output schema table, in the Structured Output component, click Open table. The Structured Output component uses the attached OpenAI model component as its "brain" to extract financial data into a DataFrame with this defined schema.

_10
| Name | Description | Type | Multiple |
_10
|--------------|-----------------------|------|----------|
_10
| EBITDA | description of field | text | False |
_10
| NET_INCOME | description of field | text | False |
_10
| GROSS_PROFIT | description of field | text | False |

  1. To inspect the template that contains the extracted data, in the Parser component, click Scan in the Template field. The Parser component converts the extracted data into formatted messages for chat consumption. Each variable receives its value from the structured outputs.

_10
EBITDA: {EBITDA} , Net Income: {NET_INCOME} , GROSS_PROFIT: {GROSS_PROFIT}

Search