The result is different after SAP Connector was changing

[hanna_choi]

Dear.

I need your help.

SAP repository is changed from Oracle to SAP HANA.

Qlik SAP Connector has been reinstalled to suit the environment.

SAP repository was changed from Oracle to SAP HANA.

Qlik SAP Connector has been reinstalled to suit the environment.

And then, The result is different after SAP Connector was changing

The Month, Quarter, Week field include zero(0) at the first of value.

CALDAY : 20220430

 CALMONTH : 0202204

CALQUARTER : 020222

CALWEEK : 0202217

Should I reinstall the SAP connector? or Should I transform it at the modeling?

Best Regard

hanna.choi

[jochem_zw]

seen this before with updating SAP connectors , you have to transform it by using the TEXT function 

[TcnCunha_M]

This is because of Upgrade on SAP +  connection, i believe inside of is an Numeric field with  7 characters and Qlik must to add a extra zero at the end of 
you can try to use: 

Right(CALMONTH ,6) 

 Right(CALQUARTER ,5) 

Right(CALWEEK ,6)

Or Trim(Num('YourField'))

should be removing the zero