Hello,
have created a P&L report in qlikview and now there will be incoming data from another company. I use intervalmatch and an excel template to group the verifications.
Example:
I have an account number 6000 that belongs to Marketing from Company A and Sales in Company B.
In the next step I do an intervalmatch that puts everything under 6000 under Marketing.
I have two different sources of excel files which I first concatenate. When, or before I do the concatenation I need to remap all 6000 accounts from Company B to a Sales account first so that when I do the final intervalmatch against the excel template the verifications will be grouped correctly.
Have tried some If( and also mapping loads but it doesn't really come out as expected.
Any help is useful.
Thx!
