Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am attempting to move some work that is currently being done offline in Excel before we load into Qlikview to be accomplished in the load script. Today, we utilize several if and vlookup functions in excel to transform data which has become cumbersome. For example:
=if(cellA2 = 123, cellB2, vlookup(c2,TABLE,2,false))
Does anyone have suggestions as to how I could accomplish that same outcome utilizing the load script?
You should be able to use a Mapping load with ApplyMap to accomplish what you are trying to do here.
Mapping Load in Qlikview: A Qlikview Tutorial « Learn Qlikview
can you provide that excel?