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]

Hi,

If the same set of data again comes then all rows of the import set should be ignored as the information is same

Regards
Ankur

[Sathwik1]

Thanks, @Ankur Bawiskar for your explanation but in my schedule scenario I was not able to understand what should I select as a coalescing field...

because please check the below scenarios

Schedule 1 "Indian holidays...scheduled entries are like below..

Independence day    AUG15

Republic day            Jan 26th

Schedule 2 "Peru Holidays"....schedule entries are like below

Independence day      28 July

So if I took the name as coalesce field then it schedules may get conflicted...because for different countries different schedules....

So earlier I took schedules as "coalesce" field but it was incorrect....so please suggest and help me ankur what field should I take as coalesce field @Ankur Bawiskar 

[Ankur Bawiskar]

Hi,

take combination of Schedule + Start + end

Regards
Ankur

[Sathwik1]

@Ankur Bawiskar 

If I do like that there is one more issue ankur, because as now I am updating calender...

So at present in indian schedule be like this

Independence day    Aug 15th 2020

so I need to update as 

Independence day    Aug 15th 2021..

If I follow as you mentioned then it will create record....but not update..

here all that I am doing is updating the calendar through transform map..for this what I did is from servicenow scheduled entries I download the excel file for one of the schedule and checked calender of the 2021 and updated in the excel, now I need to run through transform map to update it in servicenow...

Hope you will understand it clearly now @Ankur Bawiskar ,

[Sathwik1]

@Ankur Bawiskar did you get any chance to get through this?