> For the complete documentation index, see [llms.txt](https://help.auxalia.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.auxalia.com/plant-tools/plantlink/how-to-use/usage/select-different-row-from-source.md).

# Select different row from source

This chapter describes how you can select a different row (dataset) from your data source.

The images below are used from the [Create an Update Link](/plant-tools/plantlink/how-to-use/link-configurations/create-an-update-link.md) example.

The project used in this chapter can be downloaded with the following Link:

[Download Sample Project](http://documentation.auxalia.com/EN/PL%20Update%20Link.7z)

<details>

<summary>Using the Context Menu</summary>

To change the mapped data you can use the context menu from the symbol.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-ca9ecc6bb885784c89f5b9b5c27f2777d71c5b4f%2FPL-Usage-0001.png?alt=media)

Then the **PlantLink - External Database Viewer** will show up again. The row showing with a bold text is the row which is currently mapped.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-ab5f51640cbdbe5597551817d3b637379c6165e5%2FPL-Usage-0002.png?alt=media)

To assign another row's data you simply select the other row and click on **Import values**.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-c91fd57c75d0443df270b23d9b8399ba74126cc4%2FPL-Usage-0003.png?alt=media)

Now you see the change in the Properties Palette.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-c5139ce11a6d69b89fe7228b296b63b3a8e04b1f%2FPL-Usage-0004.png?alt=media)

If you open the **PlantLink - External Database Viewer** again and uncheck the box **Show only suitable datasets when using 'Assign Data'** you will be shown all rows from the table.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-ee37e9b759e39ac1e9f0fce8fdb489a614202a2d%2FPL-Usage-0005.png?alt=media)

If you select for example a heat exchanger which has a different value for PIDType, then the value for Type will also be mapped.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-70f5b9a2aa667feb496547787f6104d919c868fd%2FPL-Usage-0006.png?alt=media)

</details>

<details>

<summary>Using the Properties Palette</summary>

Any linked property used in the link configuration will trigger a reaction by PlantLink. So when changing the Type back to P...

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-4fdbb1a92840a87f197013edb841a9c56727f1bb%2FPL-Usage-0007.png?alt=media)

...then the **PlantLink - External Database Viewer** shows up again with the row filtered by PIDType=P.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-dfdeab2cba492e1a626e5b9c39da843651828b91%2FPL-Usage-0008.png?alt=media)

If you use the \~ (tilde) character...

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-0fcf8d523551656c1d82a1a7935a91274d20f3b2%2FPL-Usage-0009.png?alt=media)

...it also triggers PlantLink and the **PlantLink - External Database Viewer** opens too. Since there is no specific value given for Type, the database viewer shows again all rows from the table.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-238e95d4608d4d7fd9cc64fb40ba5b15d38ed2b8%2FPL-Usage-0010.png?alt=media)

You select a row of your choosing again and all properties will be mapped.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-f22cf5f962b214df3ef500f15941271ce9dac54e%2FPL-Usage-0011.png?alt=media)

</details>

<details>

<summary>Using Data Manager</summary>

In addition of using the AutoCAD Properties Palette or the PlantExpressTools PropertiesPalette you can also use Data Manager. When you select a Type from the selection list...

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-9f31d0a5e4d5843ad5279693cd993a6a6a5c8de1%2FPL-Usage-0012.png?alt=media)

...you will be shown the rows filtered by your selection.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-0669129fe3d570e43339a037fa7315e7b2c8bab1%2FPL-Usage-0013.png?alt=media)

Here you can also type in the \~.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-69777eb8ca38f746b90ce6fee1b52dc98a51c32b%2FPL-Usage-0014.png?alt=media)

And it opens the **PlantLink - External Database Viewer** too.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-73b221401a855211b148b58e28732b7d108b8e16%2FPL-Usage-0015.png?alt=media)

</details>

<details>

<summary>PlantDataManager</summary>

This type of link configuration works in PlantDataManager as well. See [Link Configurations](/plant-tools/plantdatamanager/how-to-use/plantdatamanager/links-calculations-properties/link-configurations.md).

</details>