i need help to work around problem. I have 2 files one with a number field and the other with country code and country name.
for example i have this number 12398564 and there is the country code 123 of country name x
My questions is should i index both files in the same index so i can use use them
my final result is that i want to take the substring of the code which returns 123 and link it with country code field 123 and returns the country name x to display it in a table next to it.
can i use scripted fields or something of a link?