topic The result is different after SAP Connector was changing in Connectivity & Data Prep

The result is different after SAP Connector was changing

hanna_choi — Mon, 11 Dec 2023 07:07:54 GMT

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

Re: The result is different after SAP Connector was changing

jochem_zw — Tue, 19 Dec 2023 07:10:09 GMT

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

Re: The result is different after SAP Connector was changing

TcnCunha_M — Tue, 19 Dec 2023 09:03:01 GMT

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