> For the complete documentation index, see [llms.txt](https://docs.qyrus.com/data-testing/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.qyrus.com/data-testing/functions-and-transformations/index/creating-functions.md).

# Creating Functions

Create reusable transformation functions for your jobs.

> **Important:** Save the job before creating functions.

## Step 1: Select a Job

* Identify the relevant job from the list.
* Click on Select for the specific job.

![Select Job](/files/dzMl4vhEM2W0ShQFpcuX)

## Step 2: Fetch Data

* Click **Fetch Data** to retrieve records from the selected source.
* Fetched data displays in a table for analysis.

![Fetch Data](/files/8FCdkOfuPRqshvemMed7)

## Step 3: View Fetched Data

* Review the data in tabular format.
* Use **Add Row** or **Clear Data** options as needed.

![View Fetched Data](/files/0YqvAizEIFBZXx9XW2Eb)

## Step 4: Generate a Function

* Enter the prompt to generate transformation function in the text editor.
* Choose **Single Column** or **Multiple Columns** mode.
* Provide a **Function Name**.
* Click **Generate** to create the function.

### Example: Single Column Function

Convert date format (`yyyy/mm/dd` → `dd/mm/yyyy`):

1. Select **Single Column** mode.
2. Choose the column (`transactiondate`).
3. Enter function name (e.g., `Date Conversion`).
4. Click **Generate**, then **Run**.
5. Review the transformed data in the table.
6. Verify the changes are correct.
7. Edit and re-run if corrections are needed.
8. Click **Save** to store the function.

![Single Column Function](/files/gBLzlW3NUJvjBLpkQZIj)

![Single Column Function](/files/6bfnLtUpdXxvnflsmf13)

### Example: Multiple Columns Function

Convert currency from rupees to dollars.

1. Select **Multiple Columns** mode.
2. Define transformation logic:
   * Convert transactionamount and accountbalance from INR to USD where currencycode = 'INR', round the converted amounts to 2 decimal places, and update currencycode to USD.
3. Enter function name (e.g., `Currency Conversion`).
4. Click **Generate**, then **Run**.
5. Review the transformed data.
6. Verify the changes are correct.
7. Edit and re-run if corrections are needed.
8. Click **Save** to store the function.

![Multiple Columns Function](/files/kQgRocumm1TxEHfBlBGK)

![Multiple Columns Function](/files/7HcHw2FDEKHz2rajeDJd)

## Step 5: View Saved Functions

* Navigate to **Saved Functions** from the left menu.
* View all created functions with details:
  * Function Name.
  * Function Type (Single or Multiple Columns).
  * Created By.
  * Created At.

![Saved Functions](/files/Vb7EEqe8xyH5JrtQpLOA)