Discussion Board for collaboration on QlikView Scripting.
I have a question and hope my english is not too bad:
I want to establish a link between SAP FI and SAP IS-U in QlikView.
For this I use the AWKEY in FI and the FIKEY (DFKKKO) in IS-U.
Unfortunately the AWKEY is like this:
and the FIKEY like that:
Is it possible to cut the AWKEY by 8 points from behind and how would the code look like for this?
Thank you very much,
Go to Solution.
In your load script, you can use
SubField(AWKEY,'-',1) AS AWKEY
LEFT(AWKEY, (Length(AWKEY)-8)) - this will take, from the left, all the letters from AWKEY minus the 8 you want to cut off.
Thank you very much Sokkorn,
it works perfectly.
You are welcome Peter.