Is it possible to merge lists?

1

Is it possible in Coda to “merge” the items of two lists? In the below example, I want to merge the blue column with the yellow column to get the (hard coded) result in the green column. Is this possible in Coda? (I’ve tried FormulaMap(CurrentValue) every way I can think to try it, but unable to get result in green column.)

merge_lists_2018-11-02_1005
merge_lists_2018-11-02_1005.png767×616 23.3 KB

1 Like
2

Hello @Ander,

Looks like you can do this with a Sequence, FormulaMap, and Slice!

[Desired Result] is:

=Sequence(1,Count(fruits),1).FormulaMap(Concatenate(fruits.Slice(CurrentValue,CurrentValue),": ",[notes.split()].Slice(CurrentValue,CurrentValue))).BulletedList()

edit: even easier with Nth instead!
[Desired Result] is:

=Sequence(1,Count(fruits),1).FormulaMap(Concatenate(fruits.nth(CurrentValue),": ",[notes.split()].nth(CurrentValue))).BulletedList()

Which produces the below, hope this helps!
Thanks, Bobby

image

3 Likes
3

@Bobby_Ritter,

nth wasn’t working for me, but your passing in of CurrentValue solves that problem.

I also couldn’t figure out how to generate that for loop, but your use of Sequence solves that problem (if I’m interpreting your formula correctly).

Thanks!

4

Thanks for your help, @Bobby_Ritter !

image
image1850×891 147 KB