Hello Everyone, I am working on two datasets. Below are the details -
I want to create a new column in 1st dataset, which will contain the "Rate" from the 2nd dataset. I want to pull the rates for each toy category present in dataset 1 based on a condition -
Date in dataset 1 should fall between the Start Date & End Date given in dataset 2.
Accordingly, the "Rate" should be filled in the new column in Dataset 1.
Please provide a solution to this.
Thank a lot in advance.