Transformation - Delimited

[#1]

Hi Experts,

Please can you help on this task..

I have attached the Delimited file. I want to transform this data using the delimated file in structure way.

If possible can you guys provide me qvw file based on this Data transformation so that I can implement this onto my current project.

Regards,

Verendra.

[MarcoWedel]

no attachment

[#3]

Oops sorry Marco Wedel I forgot to attached the Delimited files.

I have attached in my second post please have a look into this.

Thanks for your quick response.

Regards,

Verendra.

[#4]

Sorry folks Please find the attached delimited files.

Regards,

Verendra.

[MarcoWedel]

still no attachment there ...

.

[#6]

Hi Marco Wedel,

Please find the attached Delimited files .

Regards,

Verendra.

[MarcoWedel]

Hi,

yes, you can :

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD-MMM-YY';
SET TimestampFormat='DD-MMM-YY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

tabData:
LOAD [Document Sequence Name],
     [Tax Class],
     Entity,
     [GL Date],
     [VAT Code],
     [Invoice date],
     [Invoice Number],
     [Oracle Number],
     [Transaction Type],
     [Bill to Customer Name],
     [Bill To Country],
     [Ship to customer Name],
     [Ship to Country],
     [VAT Number],
     [Invoice currency],
     [Taxable Amount (invoice cur.)],
     [VAT amount (invoice cur.)],
     [Taxable Amount (funct.curr.)],
     [VAT Amount (funct.curr.)],
     [Reporting Currency],
     [Reporting Currency Conversion Rate],
     [Taxable Amount(Reporting Curr.)],
     [Vat Amount(Reporting Curr.)],
     [VAT Account],
     [GL Account],
     [GL Posting Date],
     [ISPC Code]
FROM
[File_AR_ORACLE_CM_AP6.txt]
(txt, codepage is 1252, embedded labels, delimiter is '|', msq, header is 19 lines)
Where not [Document Sequence Name] like '*END OF REPORT*';

hope this helps

regards

Marco