This content has been marked as final. Show 2 replies
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?