---
title: "Create columns in the target publish entity"
slug: "create-columns-in-the-target-publish-entity"
description: "Create a column in the target publish entity and link it to your Price IQ scenario."
updated: 2024-01-16T17:39:37Z
published: 2024-01-16T17:39:37Z
canonical: "docs.zilliant.com/create-columns-in-the-target-publish-entity"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Create columns in the target publish entity

Important

          

This topic is designed for use only by configuration teams.

Follow the procedure below to create a column in the target publish entity and link it to your scenario:

1. [Create a column](/v1/docs/create-columns-in-the-target-publish-entity#create-a-column-in-the-target-publish-entity) in the target publish entity.
2. [Add a column to the scenario configuration](/v1/docs/create-columns-in-the-target-publish-entity#add-a-column-to-the-scenario-configuration).
3. [Add a column to the Publish Price History worksheet](/v1/docs/create-columns-in-the-target-publish-entity#add-a-column-to-the-publish-price-history-worksheet).

## Create a column in the target publish entity

1. From Zilliant's IQ Interface, navigate to the **Configuration** tab.
          Note

          

Access to the **Configuration** tab is limited. If you can't access it, contact your administrator.
2. On the leftmost panel, in the **General Configuration** section, select **Entities**.
3. Select your target entity.
4. In the **Fields** section, select **Add New Field**.
5. Enter information or make selections to create a column.
6. Select **Save**.

## Add a column to the scenario configuration

1. From the  Price IQ Manager Dashboard, expand the **Setup** folder.
2. Select the **Scenario Config** workbook.
3. On the [Scenario Params](/v1/docs/price-iq-scenario-configuration#scenario-params) worksheet, verify that you've defined your target publish entity in the **Publish Target Entity** column for the needed scenario.
4. On the **Fields** worksheet, locate a row for a field you want to publish into your target entity.
5. In that row, in the **Publish Target** column, enter the system name of the column from the target entity.

## Add a column to the Publish Price History worksheet

To add a column to the **Publish Price History** worksheet in the **Negotiated Prices** workbook:

1. From the Price IQ Manager Dashboard, select **Negotiated Prices**.
2. On the **Publish Price History** worksheet, select Column and KPI Settings.
3. On the **Column** tab, select **Manage Columns**, then select **Add missing fields**.
4. Select Show for the needed column from the target entity.

The application will populate the new column on the **Publish Price History** worksheet after you [optimize prices](/v1/docs/optimize-prices) in your scenario.

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/table_60(1).png?sv=2026-02-06&spr=https&st=2026-11-12T13%3A12%3A11Z&se=2026-11-12T14%3A12%3A11Z&sr=c&sp=r&sig=8YLHjOIfU99qfEHYHAv1F8kVuzVvbPlNGkbGTWgle0s%3D)

Column and KPI Settings

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/preview_60(2).png?sv=2026-02-06&spr=https&st=2026-11-12T13%3A12%3A11Z&se=2026-11-12T14%3A12%3A11Z&sr=c&sp=r&sig=8YLHjOIfU99qfEHYHAv1F8kVuzVvbPlNGkbGTWgle0s%3D)

Show