# JSONata help ... and table node

**URL:** <https://discourse.nodered.org/t/jsonata-help-and-table-node/68339>\
**Category:** General\
**Created:** [28 September 2022 10:05 UTC](https://discourse.nodered.org/t/jsonata-help-and-table-node/68339 "2022-09-28T10:05:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manu77](https://avatars.discourse-cdn.com/v4/letter/m/8baadc/32.png) [@Manu77](https://discourse.nodered.org/u/Manu77)\
**Post date:** [28 September 2022 10:05 UTC](https://discourse.nodered.org/t/jsonata-help-and-table-node/68339/1 "2022-09-28T10:05:11Z")

</div>

I need help. I have no knowledge of jsonata. I have to transform a table output in nodered, the table comes from SQLITE.

The table I want is handwritten, one of the possibilities is to use JsoNata  
Is there any other way??  
Sorry, the table is not in English. Can anyone help?.  
Thanks

[Table.pdf](https://discourse.nodered.org/uploads/short-url/szAsFaGZfMttu1jUqcUrcqE50a.pdf) (657.3 KB)

Output SqLite Node

```auto
[{"Artigo":"ABC","Encomenda":"enc01","Turno":"Manha","QuantidadeEncomenda":5000,"Total_Produzido":36},{"Artigo":"ABC","Encomenda":"enc01","Turno":"Tarde","QuantidadeEncomenda":5000,"Total_Produzido":20},{"Artigo":"XPTO","Encomenda":"enc01","Turno":"Tarde","QuantidadeEncomenda":5000,"Total_Produzido":47},{"Artigo":"LTO","Encomenda":"enc02","Turno":"Manha","QuantidadeEncomenda":" 258 ","Total_Produzido":5},{"Artigo":"LTO","Encomenda":"enc02","Turno":"Tarde","QuantidadeEncomenda":"258","Total_Produzido":6},{"Artigo":"X3","Encomenda":"enc03","Turno":"Noite ","QuantidadeEncomenda":" 22222 ","Total_Produzido":3},{"Artigo":"LI25","Encomenda":"enc99","Turno":"Manha","QuantidadeEncomenda":5000,"Total_Produzido":52},{"Artigo":"LI25","Encomenda":"enc99","Turno":"Noite","QuantidadeEncomenda":5000,"Total_Produzido":40},{"Artigo":"LI25","Encomenda":"enc99","Turno":"Tarde","QuantidadeEncomenda":5000,"Total_Produzido":96}]

```

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [29 September 2022 08:08 UTC](https://discourse.nodered.org/t/jsonata-help-and-table-node/68339/2 "2022-09-29T08:08:44Z")

</div>

What you are asking for...

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/4/34fa83ce6c728dfcc78a801f660b296d8638f527.jpeg)

Can (and should) be done in the SQL query.

e.g.

```auto
SELECT artigo as ARTIGO, UPPER(Encomenda) as ENCOMENDA, Total_Produzio as "TOTAL PRODUCTION", QuantidadeEncomenda as "QUANTIDATE ENCOMENDA" from data;

```

Using JSONata is much slower than the database.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [28 November 2022 08:08 UTC](https://discourse.nodered.org/t/jsonata-help-and-table-node/68339/3 "2022-11-28T08:08:50Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.