DataTransformation-Delimited

Sat, 20 Sep 2014 22:08:47 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: DataTransformation-Delimited

MarcoWedel — Sat, 20 Sep 2014 23:27:52 GMT

Hi,

one solution :

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
[http://community.qlik.com/servlet/JiveServlet/download/614669-127768/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

Re: DataTransformation-Delimited

Mon, 22 Sep 2014 05:00:18 GMT

Hi Marco,

Thank you very much for help and appreciate you.

If you get a chance can you share me the screen shots step by step that would be great help.

File wizard : tranform

Regards,

Verendra.

topic Re: DataTransformation-Delimited in QlikView

DataTransformation-Delimited

Re: DataTransformation-Delimited

Re: DataTransformation-Delimited