# Replace row values in a dataset

**URL:** <https://forum.inductiveautomation.com/t/replace-row-values-in-a-dataset/67987>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 26, 2022, 10:20pm UTC](https://forum.inductiveautomation.com/t/replace-row-values-in-a-dataset/67987 "2022-12-26T22:20:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Italo\_Araujo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/italo_araujo/32/42108_2.png) [@Italo\_Araujo](https://forum.inductiveautomation.com/u/Italo_Araujo)\
**Post date:** [December 26, 2022, 10:20pm UTC](https://forum.inductiveautomation.com/t/replace-row-values-in-a-dataset/67987/1 "2022-12-26T22:20:53Z")

</div>

I would like to replace the numbers in the 'Product' column with text values.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/c/fcbf6379379acae0494738f8d71f968606805eb3.png)

Como posso editar um DataSet?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/6/b617d5783907270e432a021ff01812f1a7782d4d.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 26, 2022, 10:28pm UTC](https://forum.inductiveautomation.com/t/replace-row-values-in-a-dataset/67987/2 "2022-12-26T22:28:57Z")

</div>

Consider creating a constant dictionary of codes versus names in a project script module. Something like this:

```auto
productNames = {1: 'Something',
	2: 'Something Else',
	63: 'Chocolate',
	100: 'Vanilla'}

```

Then use it in your `view()` expression like so:

```auto
view("SELECT scriptModule.productNames.get(Producto, 'Unknown') As Producto, Volume WHERE Volume != 0", {value})

```

It can be tricky to group on a column that you are replacing, but should succumb to a bit of experimentation.

---

<div class="post-metadata">

**Author:** ![Italo\_Araujo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/italo_araujo/32/42108_2.png) [@Italo\_Araujo](https://forum.inductiveautomation.com/u/Italo_Araujo)\
**Post date:** [December 27, 2022, 11:59am UTC](https://forum.inductiveautomation.com/t/replace-row-values-in-a-dataset/67987/3 "2022-12-27T11:59:22Z")

</div>

Thanks! Worked perfectly.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/9/191fec223e15c43a032c3acb981007c30996764e.png)

I would like to group the 'Products' and add the 'Volumes', I'm trying with 'GROUP BY', but without success.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/b/4b984edae14a51828011a205b1978a1f9f90a8e9.png)

I tried like this too:

```auto
view("SELECT ROW_NUMBER() OVER(GROUP BY Produto ASC) AS 'Id', Informacoes_Producao.ListaProdutos_BD.listaProdutos_BD(Produto) AS 'Produto', sum(Volume) AS 'Volume' WHERE Volume != 0 GROUP BY 'Id' ", {value})

```

Just need to group now

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 27, 2022, 1:34pm UTC](https://forum.inductiveautomation.com/t/replace-row-values-in-a-dataset/67987/4 "2022-12-27T13:34:55Z")

</div>

You cannot use any SQL expressions in my `view()` function's PseudoSQL. It uses python expressions. You would use `Group By Producto` similar to what you did first. You might need to have your dictionary lookup produce a different output column name so the result is unambiguous.

---

<div class="post-metadata">

**Author:** ![Italo\_Araujo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/italo_araujo/32/42108_2.png) [@Italo\_Araujo](https://forum.inductiveautomation.com/u/Italo_Araujo)\
**Post date:** [December 27, 2022, 3:56pm UTC](https://forum.inductiveautomation.com/t/replace-row-values-in-a-dataset/67987/5 "2022-12-27T15:56:52Z")

</div>

I managed to solve it as follows, I took the first result and used a new expression to return the form I wanted. Thank you, your help was invaluable!

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/c/fc88f81a08a555872e904fa738731b5819b34bcc.png)