vlookup function in spotfire

[Vignesh Kannan]

Hi,

I have Two Excels

Excel 1 Value

 

 

 

Column 1

Column 2

Concat of Column 1 and 2

 

 

Apple

Cat

Apple Cat

 

 

Bannana

Rat

BannanaRat

 

 

Orange

Dog

Orange Dog

 

 

Figs

Chicken

Figs Chicken

 

 

Grapes

Frog

GrapesFrog

 

 

 

Excel 2

 

 

 

Column 1

Column 2

Concat of Column 1 and 2

 

 

Bannana

Rat

BannanaRat

 

 

Apple

Cat

Apple Cat

 

 

Grapes

Frog

GrapesFrog

 

 

Orange

Dog

Orange Dog

 

 

 

1. I want to conpare Column 1 of Excel 1 with Column 1 of excel 2 and check if value is present (value present yes value not present no)

2.I want to conpare Concat of Column 1 and 2of Excel 1 with Concat of Column 1 and 2of excel 2 and check if value is present (value present yes value not present no)

i tried using joins by joining two excels and including the above two joins keys. I want to know wheather values will be correct or any other solution there.

[David Boot-Olazabal]

Hi Viginba,You may want to have a look at this post: https://stackoverflow.com/questions/48100070/spotfire-lookup-a-value-from-a-calculated-columnrq=1Basically, you use a new data table as a lookup reference for your vlookup. This new data table is then joined to your original data on which you can perform your further analysis.Kind regards,

David