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,

you have set the schedule field as coalesce

So if it finds the schedule in schedule span and if the records are already up-to date as per the latest import row then it would ne ignored

If you have 2 rows with identical data

1) 1 row will show updated

2) 2nd row will show ignored as the 1st row already updated the target record based on coalesce

Regards
Ankur

[Sathwik1]

Hi @Ankur Bawiskar 

So how should I proceed? here my aim is to check start date and end date...suggest me how to proceed?

[Sathwik1]

HI @Ankur Bawiskar 

I was not clear ankur...can you please explain me a bit?

as per my work...there are 13 schedule entries...by  1st transform map...I have updated all 13..

next time I ran the transform map again...then 12 are again updated...only 1 is ignored..

here my requirement is to check start date and end date...if schedule is not right as a coalese field let me know what should I do

[Ankur Bawiskar]

Hi,

You need to decide what is unique in the target table

Is it Combination of Schedule + Start Date + End Date then make all 3 fields as Coalesce = True

So even if any 1 match not found then it would insert when all 3 matches then it would update

Regards
Ankur

[Sathwik1]

@Ankur Bawiskar 

Just give me clarity for below query ankur...

suppose assume in my target / source table having 4 fields

1. User ID

2. Name

3. department

4. Experience

So consider userID is a coalesce field...then 

Initially in target '0' records by first transform map we have inserted 3 records..

1.  123        sathvik  ITSM         2

2.  456         Ankur    SN           5

3.  789       shanmuk  Network   6

All three records got inserted....

If I load the same data again what will I get? whether ignored? or updated? or skipped? or anything else?