Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone verify below syntax of data extraction in Qlikview, im getting "Garbage after statement" while loading the QVW.
FactClaimsInventory:
LOAD '$(vSnapshotDate)' AS [Snap Date],
'Clean' AS [Is Clean],
Claim_Number AS [Claim ID],
Aging_Days,
Company_Number AS [Company Number],
Member_Number,
Provider_Number,
IF(Match(Provider_Number, 'NOT ON FILE','NPI') > 0, Provider_Number, 'Other') AS [Provider Number],
Vendor_ID,
Benefit_Code,
Service_Code,
CPT_Code,
Place_of_Service,
Beg_Date,
Hold_Code,
Hold_Code_Description,
Claim_Type,
External_Claim_Number,
run_date,
batch_date,
Form_code_ind,
Letter_code,
Status_code,
revind,
LOBCOD
FROM
[$(vManualInventoryPath)\$(vFolderName)\CLA35601_00_00_B.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
WHERE LEN(Claim_Number) > 0 And left(External_Claim_Number,2)<>'HM' AND Left(Claim_Number,2)<>'03'
and Company_Number = 45 and Hold_Code in('10','16','22');
Hi,
instead of in use wildmatch() , match() or mixmatch()
WHERE LEN(Claim_Number) > 0 And left(External_Claim_Number,2)<>'HM' AND Left(Claim_Number,2)<>'03'
and Company_Number = 45 and match(Hold_Code,'10','16','22');
Regards,
Prashant Sangle
Hi Prashant,
Ok i will use it and check if it is works fine. Thank you
Can you show the error message(expecting image)?
IF(Match(Provider_Number, 'NOT ON FILE','NPI') > 0, Provider_Number, 'Other') AS [Provider Number],
Here, What are you looking for? I doubt how Match with >0 working for you?
Hi Anil,
I think it will work because match() return 0 or >0 (i.e 1,2,3 etc) value
If there is match then return >0 value so this condition won't make any issue.
Regards,
Prashant Sangle
Hi Anil,
condition which you have mentioned is working fine without any errors , im only facing issues after including filters for Hold_code as mentioned above, Thank You
Make sense, What if string produces using Match over here? I doubt can i expect one example using this
Hi,
I didn't get you ? What you kind of example you want??
Regards,
Prashant Sangle