topic Re: Transformation - Delimited in QlikView

Transformation - Delimited

Sat, 20 Sep 2014 22:01:27 GMT

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.

Re: Transformation - Delimited

MarcoWedel — Sat, 20 Sep 2014 22:03:32 GMT

no attachment

Re: Transformation - Delimited

Sat, 20 Sep 2014 22:17:44 GMT

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.

Re: Transformation - Delimited

Sat, 20 Sep 2014 22:26:06 GMT

Sorry folks Please find the attached delimited files.

Regards,

Verendra.

Re: Transformation - Delimited

MarcoWedel — Sat, 20 Sep 2014 22:26:20 GMT

still no attachment there ...

Re: Re: Transformation - Delimited

Sat, 20 Sep 2014 22:35:55 GMT

Hi Marco Wedel,

Please find the attached Delimited files .

Regards,

Verendra.

Re: Transformation - Delimited

MarcoWedel — Sat, 20 Sep 2014 22:45:34 GMT

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