Data validation template

[Anonymous]

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!

[prieper]

Suggest to use a Mapping-Table:

Validation:

MAPPING LOAD MyField, CorrectContent FROM ....;

Data:

LOAD

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

...

FROM .....;

Peter

[Anonymous]

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]

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]

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