topic SAP Information in QlikView

SAP Information

pgalvezt — Mon, 20 Feb 2012 20:36:59 GMT

hello, I need to know how Can I Read just 2 columns of this SAP File please. For example I need to read all information 4504518604 ZPI 990000790 DIVISION TRE 11.01.2011 With just have Code "ZPI" and Bring me just 4504518604 in 1 Column and the date 11.01.2011 in other. Is it possible?

Example the final result would be:

PO	Date
4504385984	9/27/2010
4504533448	1/21/2011
4504586412	3/3/2011
4504601903	3/16/2011
4504619550	3/31/2011
4504623766	4/4/2011
4504623777	4/4/2011
4504625063	4/5/2011
4504633649	4/11/2011
4504654342	4/28/2011
4504682161	5/19/2011
4504696586	5/31/2011
4504699342	6/2/2011
4504707345	6/8/2011

Thanks

SAP Information

pgalvezt — Mon, 20 Feb 2012 21:31:20 GMT

Anyone?

SAP Information

disqr_rm — Mon, 20 Feb 2012 21:38:00 GMT

MyTable:

LOAD @1:11 as PO,

date#(right(@1:n, 10), 'DD.MM.YYYY') as Date

FROM C:\TMP\ME2NCL.xls (fix, codepage is 1252, header is 5 lines)

WHERE @1:3=45;

SAP Information

pgalvezt — Mon, 20 Feb 2012 21:55:41 GMT

How do you load and appear @1:11 . Just appear @.

Thanks!

Re: SAP Information

disqr_rm — Mon, 20 Feb 2012 21:56:57 GMT

Not sure what you mean.

Re: SAP Information

disqr_rm — Mon, 20 Feb 2012 21:58:09 GMT

Here is example. Place them in same folder and reload. Should work fine.