Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shawnklar
Contributor III
Contributor III

Shorten SAP BELNR from behind

Hello,


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:

13120403/MÜA-0000001

and the FIKEY like that:

13120403/MÜA


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,


Peter

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi Peter,

In your load script, you can use

SubField(AWKEY,'-',1) AS AWKEY

Regards,

Sokkorn

View solution in original post

4 Replies
datanibbler
Champion
Champion

Hi Peter,

LEFT(AWKEY, (Length(AWKEY)-8)) - this will take, from the left, all the letters from AWKEY minus the 8 you want to cut off.

HTH

Best regards,

DataNibbler

Sokkorn
Master
Master

Hi Peter,

In your load script, you can use

SubField(AWKEY,'-',1) AS AWKEY

Regards,

Sokkorn

shawnklar
Contributor III
Contributor III
Author

Thank you very much Sokkorn,

it works perfectly.

Peter

Sokkorn
Master
Master

You are welcome Peter.

Regards,

Sokkorn