Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Transformation - Delimited

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.

6 Replies
Highlighted

Re: Transformation - Delimited

no attachment

Highlighted
Not applicable

Re: Transformation - Delimited

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.

Highlighted
Not applicable

Re: Transformation - Delimited

Sorry folks Please find the attached delimited files.

Regards,

Verendra.

Highlighted

Re: Transformation - Delimited

still no attachment there ...

.

Highlighted
Not applicable

Re: Re: Transformation - Delimited

Hi Marco Wedel,

Please find the attached Delimited files .

Regards,

Verendra.

Highlighted

Re: Transformation - Delimited

Hi,

yes, you can :

QlikCommunity_Thread_134241_Pic1.JPG.jpg

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