Discussion Board for collaboration related to Creating Analytics for QlikView.
I would like to clean up the data directly in QLikView.
For instance, I would like to merge the data who have apparently same billing account, but expressed a different way,
ex. billing account has the values Company LTD and Company LIMITED, I would like to rename billing account to Company LTD when it is Company LIMITED.
is it possible to achieve so ?
where should script be done:
- in Expression tab
- in the Edit Script
could you propose a script for this simple case? more precisely, Sales Accounts should match exactly, and Billing Account should be * LTD or * LIMITED.
I am working with pivot table
could you say more precise what you mean with 'fields of the table' ?
i would like to have then
mapping load * inline [
but this is not compiling.