| T O P I C R E V I E W |
| amethyste |
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 |
| 3 L A T E S T R E P L I E S (Newest First) |
| snowli |
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 |
| amethyste |
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 |
Posted - 02/21/2023 : 11:42:19 AM
Could you try if E[join(list(H,A),list(I,B))] is what you want?
It joins list(H,A) and list(I,B) into one list
https://www.originlab.com/doc/en/LabTalk/ref/Join-func
Thanks, Snow |
|
|
