finding similar values in a column over another column in the same data table in spotfire

[Vignesh Kannan]

Hello all,

i have 3 column as shown below.

Input :

 

 

 

Column A

Column B

Column C

 

 

A

B

20

 

 

B

A

10

 

 

C

D

30

 

 

D

E

40

 

 

E

F

50

 

 

F

A

70

 

 

 

Output :

 

 

 

Column A

Column B

Column C

 

 

A

A

10

 

 

A

A

70

 

 

B

B

20

 

 

D

D

30

 

 

E

E

40

 

 

F

F

50

 

 

 

this is same as vlookup in excel but how to do in spotfire

[Kirsten Smith (she/her)]

Try this suggestion from another Community article:

 

https://community.spotfire.com/questions/lookup-function-spotfire