out of range error joining 2 datasets

abalo006

I have 2 datasets that I'm trying to left join using a contains.

but when I try to join them, I'm getting a string index out of bounds error, does this have something to do with the sized of my data source? I noticed that when I limit me left data source to 5 rows the join works fine, but when I use the full data, I get this error. The full data is around 600 rows, is there anything I can do to get around this?

---

Operating system used: windows

harsha3841

Facing similar issues. Any solution?

Turribeach

Where are the datasets stored on?

abalo006

I think the error just has to do with null values in my dataset, when I removed the nulls the error went away