Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
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
Thanks
could you say more precise what you mean with 'fields of the table' ?
i would like to have then
CleanUpMap:
mapping load * inline [
[Billing Account]
'LTD', 'LIMITED'
];
but this is not compiling.
Thanks