topic Re: Extract information from SAP in QlikView

Extract information from SAP

pgalvezt — Wed, 15 Feb 2012 13:31:08 GMT

Hello! I have a Sap report and I would like to know how extract just 2 values and left them in another columns, like Col1 Col2. I put an Excel Example.

Just I need to extract the first value within the date (In yellow).

Thanks!

Extract information from SAP

pgalvezt — Wed, 15 Feb 2012 14:47:51 GMT

Any Help?

Extract information from SAP

pgalvezt — Wed, 15 Feb 2012 15:56:49 GMT

Anyone?

Thanks!

Extract information from SAP

pgalvezt — Wed, 15 Feb 2012 15:57:38 GMT

Anyone?

Thanks!

Extract information from SAP

mkirchhofer — Wed, 15 Feb 2012 16:07:40 GMT

Hi, is the report a SAP standard transaction?

So that I can rebuild it?

regards

Mario

Extract information from SAP

pgalvezt — Wed, 15 Feb 2012 17:40:37 GMT

Yes, if you can look my example is an Excel with the data standar report from SAP.

Extract information from SAP

mkirchhofer — Wed, 15 Feb 2012 17:53:59 GMT

So please give me the name of transaction, like MB11 or what else!

Extract information from SAP

pgalvezt — Wed, 15 Feb 2012 17:55:38 GMT

ME2N

Re: Extract information from SAP

mkirchhofer — Thu, 16 Feb 2012 08:28:56 GMT

Hi,

you can try this reload source code.

Directory;
Temp:
LOAD
 Left(@1,10) as Order,
 Right(@1,10) as Order_Date,
 If(Alt(Right(@1,10),date#(Right(@1,10),'DD.MM.YYYY' ),0 ) <> 0,'X','') as Header_Flag 
FROM
[..\EX1.xls]
(biff, no labels, header is 4 lines, table is [ME2N CR ENE12$]);
Orders:
LOAD
 Order,
 Order_Date
Resident Temp
Where Header_Flag = 'X';
DROP Table Temp;

kind regards

Mario

Re: Extract information from SAP

mkirchhofer — Mon, 20 Feb 2012 11:08:25 GMT

Hi,

did the code solve your problem?

regards

Mario

Re: Extract information from SAP

pgalvezt — Mon, 20 Feb 2012 14:30:21 GMT

yes Im sorry I have worked full time and learn SAP. I have had many problems reading the information from QlikView.