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.