topic Is there any syntax error?-Garbage after statement in QlikView

Is there any syntax error?-Garbage after statement

chaitanyajami — Tue, 07 Mar 2017 09:54:56 GMT

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

Re: Is there any syntax error?-Garbage after statement

PrashantSangle — Tue, 07 Mar 2017 10:00:11 GMT

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

Re: Is there any syntax error?-Garbage after statement

chaitanyajami — Tue, 07 Mar 2017 10:15:53 GMT

Hi Prashant,

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

Re: Is there any syntax error?-Garbage after statement

Anil_Babu_Samineni — Tue, 07 Mar 2017 10:18:47 GMT

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?

Re: Is there any syntax error?-Garbage after statement

PrashantSangle — Tue, 07 Mar 2017 10:24:20 GMT

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

Re: Is there any syntax error?-Garbage after statement

chaitanyajami — Tue, 07 Mar 2017 10:47:59 GMT

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

Re: Is there any syntax error?-Garbage after statement

Anil_Babu_Samineni — Tue, 07 Mar 2017 12:38:19 GMT

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

Re: Is there any syntax error?-Garbage after statement

PrashantSangle — Tue, 07 Mar 2017 12:43:45 GMT

Hi,

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

Regards,

Prashant Sangle