| Author |
 Topic  |
|
|
amethyste
Germany
23 Posts |
 Posted - 02/21/2023 : 11:22:16 AM
|
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:
as the title says, i know that searching one column in another would be list(H,A) if we consider columns H and A.
and then to return the value of column E , we do E[list(H,A)].
I would like to search the values of two columns in two another columns and return the value of E.
I thought i would do E[list(H,A),list(I,B)] . By that i would like for it to search the values of column H in A and column I in B and return the corresponding E values.
It didn't work. any help with that? i would really appreciate it |
|
|
snowli
USA
1396 Posts |
|
|
amethyste
Germany
23 Posts |
Posted - 02/21/2023 : 11:49:54 AM
|
Thank you so much snow.
I would like for them to have the same length. join list makes joins two lists together right? |
 |
|
|
snowli
USA
1396 Posts |
Posted - 02/21/2023 : 11:59:13 AM
|
I am not exactly sure what you mean.
join just concatenates two datasets into one dataset.
If list(H,A) only returns 3 values, while list(I,B) returns 4 values, join(list(H,A), list(I,B)) will create a 7 value dataset.
Thanks, Snow |
|
|
| |
Topic |
|
|
|
Search the values of 2 columns in 2 other columns