Hi,
I wanted to copy the following SQLServer statement in my script:
WHEN @Select(Injury Detail\Injury Codes) LIKE '[289]D[0123456789][1023456789]'
From searching the web it appears that RegEx is the best solution. I went to the following web site
http://www.qlikfix.com/2010/10/18/regular-expressions-in-the-load-script/
and using the example I copied the code from the module editor as directed.
I then created the following in my script:
Injurydata:
LOAD * INLINE
[
IC
8132
9D04
7a01
2D01
7A02
8D14
];
//valid?
ICode:
LOAD
IC,
if(RegExTest(IC, '^[289]D[0-9]$')= -1, 'Yes', 'No') as ValidOD
Resident Injurydata;
This code works as required.
I then tried to use the same code on the database. The SQL load below works without the RegExTest code, but when I add the RegExTest code the load freezes :
// STAT table - 700RXX
Injury:
LOAD CLAIM_NO & CLAIMANT_NO as ClaimNo,
INJURYCODES;
SQL SELECT
CLAIM_NO,
CLAIMANT_NO,
INJURYCODES
FROM DB700RXX.dbo.STAT;
//Create detail
InjuryCode:
LEFT JOIN (Injury)
LOAD ClaimNo,
if(RegExTest(INJURYCODES, '^[289]D[0-9]$')= -1, 'Yes', 'No') as ValidOD
Resident Injury ;
I am using exactly the same code as in the in line load on the same Qlikview document, so can someone tell me why the RegExTest code does not work with the SQLServer load?
Thanks
Jason
