# Convert list into multiple rows **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [July 21, 2023, 7:20am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695 "2023-07-21T07:20:52Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![aman\_sharma](https://avatars.discourse-cdn.com/v4/letter/a/e480ec/32.png) [@aman\_sharma](https://forum.inductiveautomation.com/u/aman_sharma)\ **Post date:** [July 21, 2023, 7:20am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/1 "2023-07-21T07:20:52Z")
hi, i am getting the data in list which is list under list. so i want to print the data into multiple rows in label component. i have 20 field so i want to print 20 rows which shows individual data. i tried this code: ds = system.dataset.toDataSet(['Column Name'], [for x in list1]) return ds but not working please guide me ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 21, 2023, 8:05am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/2 "2023-07-21T08:05:08Z")
Something like this? ```auto # data = your list of lists return '\r\n'.join(','.join(row) for row in data) ``` ---
**Author:** ![aman\_sharma](https://avatars.discourse-cdn.com/v4/letter/a/e480ec/32.png) [@aman\_sharma](https://forum.inductiveautomation.com/u/aman_sharma)\ **Post date:** [July 21, 2023, 9:39am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/3 "2023-07-21T09:39:48Z")
> [@nminchin](#): > > `return '\r\n'.join(','.join(row) for row in data)` also i want to know that, am i doing right binding with the label component or shall i take different one? because In label, data cannot be separated into the rows. please guide me ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 21, 2023, 9:43am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/4 "2023-07-21T09:43:54Z")
Are you passing text in? Or the list of lists (as objects) ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 21, 2023, 9:47am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/5 "2023-07-21T09:47:01Z")
I'm not really sure what your end goal is. What are you trying to achieve? ---
**Author:** ![aman\_sharma](https://avatars.discourse-cdn.com/v4/letter/a/e480ec/32.png) [@aman\_sharma](https://forum.inductiveautomation.com/u/aman_sharma)\ **Post date:** [July 21, 2023, 9:47am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/6 "2023-07-21T09:47:46Z")
i am getting the data from sql and append into the list by using transform. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 21, 2023, 9:51am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/8 "2023-07-21T09:51:17Z")
A sql query returns a dataset, not a list though. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 21, 2023, 9:51am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/9 "2023-07-21T09:51:57Z")
Can you show me an example of the output you want? And where are you wanting to display it? ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 21, 2023, 9:56am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/11 "2023-07-21T09:56:10Z")
You should never read tags 1 by 1, always read them in a single read by adding the tags into a list. A few other things as well, but too hard to type on my phone, I'll come back to these in an hr. I still don't know what you're expecting to see as a result? It looks like this would be better presented in a table ---
**Author:** ![aman\_sharma](https://avatars.discourse-cdn.com/v4/letter/a/e480ec/32.png) [@aman\_sharma](https://forum.inductiveautomation.com/u/aman_sharma)\ **Post date:** [July 21, 2023, 10:01am UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/12 "2023-07-21T10:01:34Z")
yes thatswhat i am also thinking ---
**Author:** ![aman\_sharma](https://avatars.discourse-cdn.com/v4/letter/a/e480ec/32.png) [@aman\_sharma](https://forum.inductiveautomation.com/u/aman_sharma)\ **Post date:** [July 21, 2023, 1:08pm UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/14 "2023-07-21T13:08:58Z")
i want it on a label, not on a table. ---
**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:** [July 21, 2023, 1:13pm UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/15 "2023-07-21T13:13:23Z")
Labels display text, not rows. What are you actually trying to do? ---
**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Post date:** [July 21, 2023, 1:17pm UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/16 "2023-07-21T13:17:58Z")
Configure a table so that the gridlines are hidden and the background color is the same as the background of your window. It will look the same. ---
**Author:** ![aman\_sharma](https://avatars.discourse-cdn.com/v4/letter/a/e480ec/32.png) [@aman\_sharma](https://forum.inductiveautomation.com/u/aman_sharma)\ **Post date:** [July 21, 2023, 1:40pm UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/17 "2023-07-21T13:40:53Z")
how to hide gridlines in table ---
**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Post date:** [July 21, 2023, 1:42pm UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/18 "2023-07-21T13:42:19Z")
Vision or perspective? ---
**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:** [July 21, 2023, 1:45pm UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/19 "2023-07-21T13:45:28Z")
{ The first screenshot is unambiguously Perspective. Adding the topic tag.. } ---
**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Post date:** [July 21, 2023, 1:56pm UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/20 "2023-07-21T13:56:36Z")
🤦‍♂️ probably some CSS stuff then. I'm neck-deep in Vision at the moment, so I couldn't tell you without messing with it, but it should definitely be possible. ---
**Author:** ![tupanaster](https://avatars.discourse-cdn.com/v4/letter/t/5daacb/32.png) [@tupanaster](https://forum.inductiveautomation.com/u/tupanaster)\ **Post date:** [July 21, 2023, 2:02pm UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/21 "2023-07-21T14:02:02Z")
Is that Ignition's test to get a gold certification? 🧐 I think you can get what you need from your original query. From a dataset you can get a list and from a list you can make a single label with new lines ('\n') that can be shown in a single label component. [https://docs.inductiveautomation.com/display/DOC81/Datasets](https://docs.inductiveautomation.com/display/DOC81/Datasets) I don't think you should read tags from that SQL query as they don't provide any information for it. ---
**Author:** ![Paolo.Mariani](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paolo.mariani/32/3285_2.png) [@Paolo.Mariani](https://forum.inductiveautomation.com/u/Paolo.Mariani)\ **Post date:** [July 21, 2023, 2:41pm UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/22 "2023-07-21T14:41:01Z")
---
**Author:** ![Paolo.Mariani](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paolo.mariani/32/3285_2.png) [@Paolo.Mariani](https://forum.inductiveautomation.com/u/Paolo.Mariani)\ **Post date:** [July 21, 2023, 2:42pm UTC](https://forum.inductiveautomation.com/t/convert-list-into-multiple-rows/76695/23 "2023-07-21T14:42:14Z")
@aman_sharma This is using the same data as our Gold Certification test. The gold certification test does need to be your own work, not the work of people on the forums. The test document outlines what resources you can use to take the test.