Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Suggest to use a Mapping-Table:
Validation:
MAPPING LOAD MyField, CorrectContent FROM ....;
Data:
LOAD
FieldToCheck = APPLYMAP('Validation', KeyField) AS Check,
...
FROM .....;
Peter
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.
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
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);