Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bharath8
Contributor II
Contributor II

Data validation template

Hi All,

Our data team receive data in spreadsheet on monthly basis and they paste it to the main spreadsheet(by mapping to the correct columns) which is source to qlikview dashboard. The main spreadsheet also does validation checks of newly pasted data with the help of lookup tables.

I wanted to create a qlikview application which will map the received data file and also validate the data which I mentioned above.

Does anyone help me with a template qlikview application that helps me to start with.

Thanks!

4 Replies
prieper
Master II
Master II

Suggest to use a Mapping-Table:

Validation:

MAPPING LOAD MyField, CorrectContent FROM ....;

Data:

LOAD

FieldToCheck = APPLYMAP('Validation', KeyField)               AS Check,

...

FROM .....;

Peter

bharath8
Contributor II
Contributor II
Author

Hi Peter,

Thanks for your suggestion.

I am aware of the steps I need to take in order to create this document.

I though if I have a  template, I can start modifying it as per my requirement, instead of starting from scratch.

ziadm
Specialist
Specialist

I would suggest creating a log file where all errors and validation are kept on the ...

They I would do that creat a log file and check all the apply maps that is do not exist or mapped to unknown

filter them in table and log them into the txt file

write variable to file using macro

ziadm
Specialist
Specialist

Other approach is to write the Table int csv format where Field = unknowkn

ErrorTable:

load *

resident Table1

where MappedFiled = 'unknown';

store ErrorTable into c:\myfiles\errortable.csv (csv);