Is there any syntax error?-Garbage after statement

[chaitanyajami]

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');

[PrashantSangle]

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

[chaitanyajami]

Hi Prashant,

Ok i will use it and check if it is works fine. Thank you

[Anil_Babu_Samineni]

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?

[PrashantSangle]

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

[chaitanyajami]

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

[Anil_Babu_Samineni]

Make sense, What if string produces using Match over here? I doubt can i expect one example using this

[PrashantSangle]

Hi,

I didn't get you ? What you kind of example you want??

Regards,

Prashant Sangle