Cloud platform integration data services lookup function error

[former_member1339977]

Hi

While using lookup function(Mapping is atatched in above) in SAP CPI-DS,am getting error.

My source is excel file.

Lookup is also file with csv.

1. How to compare range expressions in CPIDS lookup function.

My requirement is like below.

Source file:

locid prdid mmvalidfrom mmvalidto

1 1001 01/07/2019 31/07/2019

2 1002 01/08/2019 31/08/2019

3 1003 01/09/2019 30/09/2019

Lookup file :

Period start period end

30/06/2019 28/07/2019

29/07/2019 26/08/2019

27/08/2019 30/09/2019

Now i need to lookup date values from source file to lookup file like sourcefilemmvalidfrom >= lookup file period start value then my result value is lookup file periodstart.

So in which way i can apply comparision with > = or <= in lookup function.

2. Am getting below error while using lookup function.

Severity Message ------------------------------------------------------------------------------------------------------------------- ERROR Column [MMIDVALIDFROM]: Unknown identifier: <IBP_DSG_FF."25122018_TEMPLATE"."25122018_TEMPLATE.csv">

I need to compare date range values from lookup file.Please help me on below error and suggest how to compare date range expressions.

Regards,

Mahesh