+sign not appearing in Fields values

[#1]

Hi ,

I am Creating a QVD from SAP data base , I used  certain fields to create a Key but when I see the data used in Key fields individually the sign before the data is ignored. Please seen screenshot for example  . I want these sing to appear and also note this field contains both text and number

[#2]

Hi,

Use  "=SubField(%Key,'/',4) " this expression in your Filed used in key expression.

If this is not working let me know the issue in details.

Thanks,

[jagan]

Hi,

Convert that dimension into Text field and load into QVD like this

LOAD

     Text(Dim1) AS Dim1,

'

'

FROM DataSource;

Regards,

Jagan.

[#4]

I have tried both but results it give is 030 for above example, where as I want +30.

For more information I am loading QVD in to new QVW file for which data has been pulled from SAP and Key filed give the exact match but not the individual field. 

[jagan · Accepted solution]

Hi Mahesh,

Try like this

Test:

LOAD
Value,
Text(SubField(Value, '/', 4)) AS Key
INLINE [
Value
3300/10/50/+30/E];

Regards,

Jagan.