topic Re: Can any one Help In QlikView Error Handling mechanism in QlikView

Can any one Help In QlikView Error Handling mechanism

Thu, 25 Sep 2014 19:58:41 GMT

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.

Re: Can any one Help In QlikView Error Handling mechanism

Thu, 25 Sep 2014 20:02:48 GMT

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

Re: Can any one Help In QlikView Error Handling mechanism

Fri, 26 Sep 2014 03:52:07 GMT

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

Thanks

Re: Can any one Help In QlikView Error Handling mechanism

jagan — Fri, 26 Sep 2014 05:11:31 GMT

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.

Re: Can any one Help In QlikView Error Handling mechanism

Fri, 26 Sep 2014 07:01:21 GMT

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

Re: Can any one Help In QlikView Error Handling mechanism

Fri, 26 Sep 2014 08:47:36 GMT

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 :

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

Re: Can any one Help In QlikView Error Handling mechanism

Fri, 26 Sep 2014 09:44:38 GMT

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 :

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

Re: Can any one Help In QlikView Error Handling mechanism

Fri, 26 Sep 2014 10:25:05 GMT

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 :

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