Working with strings

[#1]

Hello, I need help with this:

I have two excel files but NO common field (file 1 and file 2)

I need to see how identify the employees1 of file 1 (Garcia Fernandez Luis) with the employees2 of the other file 2 (Luis G.) In File 1

Finally I have to replace the field containing (Garcia Fernandez Luis) for file 2 field (Luis G.)

Can you give me some idea? I'm very lost. Thank you

[#2]

Thank you very much.

I have tried this and it works!

SubField([Employees1],' ',1)&' '&LEFT(SubField([Employees1],' ',2),1)&'.' AS [Employees2]

Continue ...

[Anonymous]

If someone answered your question please close the thread.

Qlik Community Tip: Marking Replies as Correct or Helpful