Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
Contributor II
Contributor II

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.

Highlighted
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

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