Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
DIRECTORY;
log:
load
FileName() as QVDNames
from
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
Tried with above process not working can any one help me out.
Thanks
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.
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
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
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
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