Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am looking to join two fields together from two tables thus creating a join. My problem is the data is in a different format although data on both sides contains one common string of 6 numbers, which I want to use as my key.
Table A will have data such as CRM678916, 776423NORTH, SOR234445CRM etc.
Table B Will have SORD-678916, SORD-776423, SORD-234445 etc.
Notice the strings of numbers are the same. I need to manipulate in my script both fields so they only display the first six numbers it finds in the string. I can do it in excel but not Qlikview can anyone help?
Thanks
Stuart
If you want to essentially keep the numeric letters, try
keepchar(FIELD, '0123456789')
If you want to essentially keep the numeric letters, try
keepchar(FIELD, '0123456789')
Wow didn't think it was that simple - the excel formula wasn't!
Thanks a million I'll give it a try.
Stu