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: 
arvind_patil
Partner - Specialist III
Partner - Specialist III

Data Extraction issue from SAP

Hi Experts,

I am Fetching data from SAP . The SAP Connector is 5.802211. When I fetch a huge data Maximum data Is correct but in some fields i Get Exclamatory marks Before some fields and last digit Missing in that .

Please suggest me what Can I do to resolve this

Date and Data.png

Thanks,

Arvind Patil

3 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III
Author

Any Help regarding above issue

Thanks,

Arvind Patil

Anil_Babu_Samineni

Not sure about that. What if you used Num() in qlikview.. Can you show the variant from SAP values how looks like..

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
arvind_patil
Partner - Specialist III
Partner - Specialist III
Author

Sorry !

But I am new in SAP  Do You mean script how I fetch Data.

select SAPREPORT (REPORT (ABC), VARIANT (CBD), ROWS_PER_RECORD (1), FIELD_START_POSITIONS (1, 10, 11, 46, 47, 71, 72, 77, 78, 93, 94, 108, 109, 113, 114, 130, 131, 171, 172, 186, 187, 208, 209, 220, 221, 248, 249, 262, 263, 276, 277, 288, 289,302,303,312,313,325,326,343,344,360,361,396,397,408,409,429,430,445,446,466,467,480,481,511,512,525,526,542,543,557,558,569,570,589,590,604,605,624,625,633,634,639,640,653,654,663,664,692,693,709,710,730,731,744,745,757,758,793,794,804,805,815,816,826), SKIP (T (1), T (2), T (3), T (4)), HEADER (T (5)));

Thanks

Arvind patil