# Creating a new table with multiple rows in Canvas

**URL:** <https://discuss.elastic.co/t/creating-a-new-table-with-multiple-rows-in-canvas/289057>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [November 12, 2021, 9:58am UTC](https://discuss.elastic.co/t/creating-a-new-table-with-multiple-rows-in-canvas/289057 "2021-11-12T09:58:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bodach](https://avatars.discourse-cdn.com/v4/letter/b/a87d85/32.png) [@bodach](https://discuss.elastic.co/u/bodach)\
**Post date:** [November 12, 2021, 9:58am UTC](https://discuss.elastic.co/t/creating-a-new-table-with-multiple-rows-in-canvas/289057/1 "2021-11-12T09:58:34Z")

</div>

Hello,

I am trying to create a new table based on 2 different queries.

But its only giving me the first row:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/c/7ca91cdcb09dcaae8150c94fe589073c14dc3c71.png)

This is my code:

```auto
var_set
  name="Relet" value={essql "select Service_Provider, round(avg(Score),2) as a from (select Answer, Service_Provider, Response_ID, Question_code, case when Answer=60 or Answer=80 or Answer=100 then 1 else 0 end as Score from \"preprocessed_transformed\" where Question_code IN ('Reletting') and client='yes' and record_type='survey_metric') group by Service_Provider" }
  name="Share" value={essql "select Service_Provider,round(avg(Score),2) as b from (select Answer, Service_Provider, Response_ID, Question_code, case when Answer=60 or Answer=80 or Answer=100 then 1 else 0 end as Score from \"preprocessed_transformed\" where Question_code IN ('Share_Of_Wallet') and client='yes' and record_type='survey_metric') group by Service_Provider" }
| createTable ids="Reletting" ids="Share_Of_Wallet" ids="Provider" 
| mapColumn "Reletting" fn={ var "Relet" |getCell "a" }
| alterColumn column="Reletting" type="number"
| mapColumn "Share_Of_Wallet" fn={ var "Share" |getCell "b" }
| alterColumn column="Share_Of_Wallet" type="number"
| mapColumn "Provider" fn={var "Share" | getCell "Service_Provider"}
| alterColumn column="Provider" type= "string" 

| render

```

If I use one of the queries, I see that it has a lot of rows:

![image](https://us1.discourse-cdn.com/elastic/original/3X/7/a/7aa891dbaf51d7ad5ea292bacfd885c09e2153ae.png)

```auto
essql query="select Service_Provider,round(avg(Score),2) as b from (select Answer, Service_Provider, Response_ID, Question_code, case when Answer=60 or Answer=80 or Answer=100 then 1 else 0 end as Score from \"preprocessed_transformed\" where Question_code IN ('Share_Of_Wallet') and client='yes' and record_type='survey_metric') group by Service_Provider"
| table
| render

```

I even tried it with 1 mapping, but it still giving me 1 row:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/0/e032aedc58ae751c8b161e3baaa32d80b977583b.png)

```auto
var_set
  name="Relet" value={essql "select Service_Provider, round(avg(Score),2) as a from (select Answer, Service_Provider, Response_ID, Question_code, case when Answer=60 or Answer=80 or Answer=100 then 1 else 0 end as Score from \"preprocessed_transformed\" where Question_code IN ('Reletting') and client='yes' and record_type='survey_metric') group by Service_Provider" }
| createTable ids="Reletting"
| mapColumn "Reletting" fn={ var "Relet" |getCell "a" }
| render

```

How can I get all the rows while creating a new table with 3 columns?

---

<div class="post-metadata">

**Author:** ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)\
**Post date:** [November 14, 2021, 9:48am UTC](https://discuss.elastic.co/t/creating-a-new-table-with-multiple-rows-in-canvas/289057/2 "2021-11-14T09:48:52Z")

</div>

Well I guess the issue is that you are using getCell function. Are you shure that this returns the full table?

Also.. did you try to use the debug output to find the issue?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 12, 2021, 9:49am UTC](https://discuss.elastic.co/t/creating-a-new-table-with-multiple-rows-in-canvas/289057/3 "2021-12-12T09:49:18Z")

</div>

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