Discussion board where members can get started with QlikView.
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.
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.
yes, you can :
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimestampFormat='DD-MMM-YY hh:mm:ss[.fff]';
LOAD [Document Sequence Name],
[Bill to Customer Name],
[Bill To Country],
[Ship to customer Name],
[Ship to Country],
[Taxable Amount (invoice cur.)],
[VAT amount (invoice cur.)],
[Taxable Amount (funct.curr.)],
[VAT Amount (funct.curr.)],
[Reporting Currency Conversion Rate],
[Taxable Amount(Reporting Curr.)],
[Vat Amount(Reporting Curr.)],
[GL Posting Date],
(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