How to compare string field with reference field in transform map?

[Sathwik1]

I have a field in Excel named "Schedule" it maps with "Schedule" in cmn_schedule_span table...

so here my issue is...

Suppose in Excel If I provide like "India Schedule" while transforming it is referring to "Schedule" which is a reference field due to this my transform map is not working...

so can anyone please explain how can we compare a string with reference field in transform map 

[Ankur Bawiskar]

@Sathwik 

Hope you are doing good.

Did my reply answer your question?

If so, please mark appropriate response as correct & helpful so that the question will appear as resolved for others who may have a similar question in the future.

Thanks!
Ankur

[Ankur Bawiskar]

@Sathwik 

Hope you are doing good.

Did my reply answer your question?

If so, please mark appropriate response as correct & helpful so that the question will appear as resolved for others who may have a similar question in the future.

Thanks!
Ankur

[Sathwik1]

@Pranav Bhagat can you please help me with the above requirement?

[Ankur Bawiskar]

@Sathwik 

Hope this helps.

If my response helped you please mark it correct to close the question so that it benefits future readers as well.

Regards
Ankur

[Sanket10]

Hi Ankur,

This solution is really great!

Thank you.