Can any one Help In QlikView Error Handling mechanism

[#1]

Hi Friends,Tomorrow Having Demo to Clients on QlikView  can any one help on this problem.

We have a Shared Drive where Every Month Data Files like source(.txt &excel files)will be Uploaded.

Following are considerations need to be checked Before Loading in to QlikView .

1)Verify File is Available like Extension with a Standard Naming Covertion(<Source A>Bytes<File Name>.extension)

2)How End User Should Know Data in Application in Updated one or Not?Any function on .qvw?

3)While Uploading Data Sources into QlikView how to check Some Dimensions Should not Take Null Values.If there are Null Values

it should show Error message.File Contain null Values Aborted eg: Below .

Customer ID	Transactions	Amount
123	Pending	23
234	Conform	356
345	-	64
0		23

Customer ID should not be Null it should not load in to QlikView like any script is There.

[#2]

DIRECTORY;

log:

load

FileName() as QVDNames

from  (qvd);

load

QVDNames,

IF(match(QVDNames,'abc.QVD')=1,'Y','N') as ABCFlag

Resident log;

Like this any possiblities is there for checkind .qvd,.qvw,.txt,.xlx format files

[#3]

Tried with above process not working can any one help me out.

Thanks

[jagan]

Hi Srikanth,

Try like this

load

QVDNames,

IF(WildMatch(QVDNames,'*.QVD', '*.qvw', '*.txt', '.xlsx'),'Y','N') as ABCFlag

Resident log;

Hope this helps you.

Regards,

Jagan.

[#5]

For 1st point: members have already given solution

2nd: You can have variable set in the script, which will take the maximum value of date available of good data. And then use it show on front end.

3rd: We can use ReloadTime() function of qlikview to see when last the file was reloaded.

You can add Trace  comments in the script and add validations to abort the script using Exit Script or manually creating a error to create and make the file fail.

This is how we are using:

Thanks,

Angad

[#6]

Jagan and Angad Thanks for your replay.I'm not Getting exactly Business team Asking Questions like

We have Shared Path monthly Records are Placed we need to take new Records.

We are having Two source Systems.Naming convertions As below:

First :

<Source 1><File Name1><Country1><Month-Year>

<Source 2><File Name2><Country2><Month-Year>

Like .txt,.xlx,.qvd like all extensions are in same naming conversion checked

Verify file extension, naming convention and hashtotal .

Step-2:Specific Columns in Source Systems Should check not Containing any Blank Values dummy Spaces

Step 3: If all are Correct load whole Latest data if not inform Authorized Person

Like this any Scenario All are following in Qlikview Upload process and Error Handling Mechanism

[#7]

Jagan  Thanks for your replay.I'm not Getting exactly Business team Asking Questions like

We have Shared Path monthly Records are Placed we need to take new Records.

We are having Two source Systems.Naming convertions As below:

First :

<Source 1><File Name1><Country1><Month-Year>

<Source 2><File Name2><Country2><Month-Year>

Like .txt,.xlx,.qvd like all extensions are in same naming conversion checked

Verify file extension, naming convention and hashtotal .

Step-2:Specific Columns in Source Systems Should check not Containing any Blank Values dummy Spaces

Step 3: If all are Correct load whole Latest data if not inform Authorized Person

Like this any Scenario All are following in Qlikview Upload process and Error Handling Mechanism

[#8]

Thanks Angad Singh can you please Explain detail .I'm not Getting exactly Business team Asking Questions like

We have Shared Path monthly Records are Placed we need to take new Records.

We are having Two source Systems.Naming convertions As below:

First :

<Source 1><File Name1><Country1><Month-Year>

<Source 2><File Name2><Country2><Month-Year>

Like .txt,.xlx,.qvd like all extensions are in same naming conversion checked

Verify file extension, naming convention and hashtotal .

Step-2:Specific Columns in Source Systems Should check not Containing any Blank Values dummy Spaces

Step 3: If all are Correct load whole Latest data if not inform Authorized Person

Like this any Scenario All are following in Qlikview Upload process and Error Handling Mechanism