Value lookup key
Hi,
Would like to enquire advise any node to amend data from multiple column to 1 column then lookup number from excel to excel. As tried to use value lookup node, the result shows in image 3 where numbering only lookup into the first number but desired output is image 4.
Image 1: Excel 1
image 2: Excel 2
Image 3: output
Image 4: Desired output to be