QUANTRIX 2018

Merge 2 ranges into one as parameters for select() function?

Join the discussion on using Formulas and Functions in Quantrix

Moderator: Moderators

Merge 2 ranges into one as parameters for select() function?

Postby jlin » Tue Mar 27, 2018 3:55 am

Is there any way to merge two distinct ranges into one continuous list, for the purpose of feeding it to select() functions? I tried the following:
Code: Select all
select(list(ValueRange1, ValueRange2), list(KeyRange1, KeyRange2), lookup_value


However, instead of each of the list() functions evaluating to a single list whose length is equal to the lengths of ValueRange1 + ValueRange2, the lists only contain 2 items; the first item from the first range, followed by the first item from the 2nd range. I have looked for other functions that can merge multiple lists into one but I don't see anything applicable.

Is there a solution to my problem?
jlin
Quantrix Forum Member
 
Posts: 51
Joined: Mon Jan 27, 2014 10:16 am

Return to Formulas and Functions

Who is online

Users browsing this forum: No registered users and 0 guests