# \[Solved\] Join two columns from airtable into a listviewer
**URL:** https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845
**Category:** Questions about Thunkable X
**Tags:** solved
**Created:** [February 20, 2020, 9:18am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845 "2020-02-20T09:18:17Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)
#### Post date: [February 20, 2020, 9:18am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/1 "2020-02-20T09:18:17Z")
I am sure I have seen this done many times but have searched to no avail.
I have two columns in airtable that I bring back into my app and want to place the values side by side in the list viewer. I know this will be simple but I just canβt see how! wasting so much time so thought I would ask!
---
### Author:  [@kartik14](https://community.thunkable.com/u/kartik14)
#### Post date: [February 20, 2020, 10:41am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/2 "2020-02-20T10:41:21Z")
Hi, @Tina_Fountain! π
Try these blocks -
After everything, set the `x` variable to the list viewer.
Thanks! π
---
### Author:  [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)
#### Post date: [February 21, 2020, 12:50am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/3 "2020-02-21T00:50:26Z")
Thanks for help, however I want to concatenate the name and the points rather than have them following on.so each item in the list would have the persons name and the corresponding points side by side I did try creating 3 new lists one for each column and then a 3rd for joining them together via a loop. but no joy!
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [February 21, 2020, 2:07am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/4 "2020-02-21T02:07:45Z")
Create var x, y, z (empty list)
Step 1 putting the first column into var x
Next. Put second column into var y
Last in a loop that lasts while length of x is greater than 0, in list z add last as (join with text block) insert last as( get and remove first from list )with get and remove first from list y
---
### Author:  [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)
#### Post date: [February 21, 2020, 2:38am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/5 "2020-02-21T02:38:22Z")
Thanks again. this is what I have but nothing now displays. I have tried a couple of ways but missing something!
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [February 21, 2020, 2:39am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/6 "2020-02-21T02:39:25Z")
Iβll make a sample for you shortly. Gotta put my kids to bed for now π΄
see screen4, it should be the first that loads.
[https://x.thunkable.com/copy/849697b7e276cfba6ad74782afb44a07](https://x.thunkable.com/copy/849697b7e276cfba6ad74782afb44a07)
I only added a delay in the loop for the visual effect. you can βwatch the appβ join and display text instead of it all happening too fast to see π
---
### Author:  [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)
#### Post date: [February 21, 2020, 6:07am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/7 "2020-02-21T06:07:12Z")
Fantastic. and it makes sense now I have seen it, totally missed the get and remove option.
thanks for your help I will pay it forward!
---
### Author:  [@kartik14](https://community.thunkable.com/u/kartik14)
#### Post date: [February 21, 2020, 7:13am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/8 "2020-02-21T07:13:56Z")
@jared Incredible Solution! π
BTW, the `get and remove` block seems new; Is it?
Thanks! π
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [February 21, 2020, 7:16am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/9 "2020-02-21T07:16:18Z")
@kartik14, I learned about that block when I made my first random shuffled study app. Using this block + the shuffle list block, I can shuffle a list of questions on screen open, and then work my way through one by one until all questions have been seen once.
This way you donβt have to use an incrementing variable to work your way through a list of items if you plan to use them all.
---
### Author:  [@kartik14](https://community.thunkable.com/u/kartik14)
#### Post date: [February 21, 2020, 7:16am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/10 "2020-02-21T07:16:55Z")
Oh π
I missed that useful block π
Thanks, @jgibb20189! π
---
### Author:  [@neutronic\_force7](https://community.thunkable.com/u/neutronic_force7)
#### Post date: [July 8, 2020, 3:38pm UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/11 "2020-07-08T15:38:31Z")
Hi Jared,
I am new to thunkable and I saw that you help a lot to the users. So thanks a lot.
I take the chance to ask something related to this post that I did not see anywhere. Do you know if it is possible to do the same with something similar to your example but separating the lists in two columns? I mean the β1,11β, β2, 12β , β¦ that you have but
β1β β11β
β2β β12β
β3β β13β
and so on? and, would it be possible to add pictures instead of β1β, β2β, β3β?.
Thanks in advance!
---
### Author:  [@ridmaabeysundaratc1](https://community.thunkable.com/u/ridmaabeysundaratc1)
#### Post date: [September 28, 2020, 6:09am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/12 "2020-09-28T06:09:42Z")
I learnt how you join two list together in this example. Thanks for that. (app\_list3 = app\_list1 + app\_list2)
Now i have another question.
Can you please teach me how to separate app\_list3 into app\_list1 and app\_list2. (app\_list1 + app\_list2 = app\_list3)
Thank you
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [September 28, 2020, 8:10am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/13 "2020-09-28T08:10:27Z")
List = [β1,11β, β2, 12β, β3,13β]
foreach i in List{
pair = get[i].split(",");
pair[0] - for first list
pair[1] - for second list
}
---
### Author:  [@ridmaabeysundaratc1](https://community.thunkable.com/u/ridmaabeysundaratc1)
#### Post date: [September 28, 2020, 8:24am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/14 "2020-09-28T08:24:32Z")
Can you please show how to do this in blocks. Thank you
@actech
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [September 28, 2020, 11:27am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/15 "2020-09-28T11:27:47Z")
To do this, I suggest that you study the blocks for working with the list by reference.
[http://droidscript.ru/main/statyi/thunkableios\_blockhelper.php](http://droidscript.ru/main/statyi/thunkableios_blockhelper.php)
PS
Please create a new topic for each new question.
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 11:24am UTC](https://community.thunkable.com/t/solved-join-two-columns-from-airtable-into-a-listviewer/474845/16 "2024-11-08T11:24:57Z")