Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two fields: Product and Real Product
Product | Real Product | Match |
---|---|---|
AL-111 | AL-111MO | Y |
CA-172 | CA-183LA | N |
MA-912 | MA-912MO | Y |
MA-912 | MA-819MO | N |
I want a new field, 'Match' that uses these two fields. If they first 5 characters are identical, I want the 'Match' field to say 'Y'. If not, 'N'
Try something like:
if(left([Read Product],5) = left(Project,5), 'Y','N')
Try something like:
if(left([Read Product],5) = left(Project,5), 'Y','N')