topic Data validation template in QlikView

Data validation template

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Data validation template

prieper — Fri, 12 May 2017 14:42:23 GMT

Suggest to use a Mapping-Table:

Validation:

MAPPING LOAD MyField, CorrectContent FROM ....;

Data:

LOAD

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

...

FROM .....;

Peter

Re: Data validation template

Anonymous — Fri, 12 May 2017 14:58:39 GMT

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.

Re: Data validation template

ziadm — Fri, 12 May 2017 18:45:11 GMT

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

Re: Data validation template

ziadm — Fri, 12 May 2017 18:47:55 GMT

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