on 2014 Nov 06 5:45 PM
Hi Gurus,
We are loading the data from flat file. The data in one column say for Account comes with special characters ex ACCT123.$, I would like to convert it to ACCT123 (remove .$).
Tried using the conversion file for Account with below combinations
External | Internal |
*.$ | * |
*.$ | js:%external%.replace(".$","") |
*.$ | js:%external%.toString().replace('.$','') |
*.$ | RG_TEST |
However, it doesn't work. It doesn't convert to "RG_TEST" as well. It throws an error for ACCT123.$ doesn't exists in ACCOUNT dimension.
Looks like it doesn't recognise $ in External column.
We are on BPC 10NW SP6 on HANA
HANABPC SP4
SAP BW 7.31 SP8
Please suggest.
Let me know if you need more information.
Regards,
Rashmi
Request clarification before answering.
Hi,
Try this:
Use
Convert_internal = YES ( if you putting the in external column)
and then add your java script code.
js: %external%.replace(".$", " ")
Prat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.