Import txt file - difficult format

Tue, 03 Apr 2012 08:14:23 GMT

Hi folks!

Maybe someone is able to help me.

I have to import txt files to qv which are in a difficult format. Due to the reason that there are allready a lot of historical txt files in this format there is no way to change the format to an easier to handle format.

I added dummy data to show the problem. Some explanations to the data:

Withe the field "pos" a special teststation is named - the followoing fields include the definition regarding the teststation - the cnt fields show the sum of the cnt fields in the partnumber information. With every teststation are in a second level the partnumbers connected and also the amount of tests (cnt fields). The dummy data show two teststations and a few materials. My job is to import the fields into qv to show teststations and the sum of tests and in a second layer the parts per teststation. Has any one an idea how to import data in a format like shown in the included txt file? Thanks for any help in advance.

Re: Import txt file - difficult format

Wed, 26 Sep 2012 14:56:04 GMT

To All, who are interested in.

I found a solution using the QV Transformation

Just load the txt file as table - press next and then transform

topic Re: Import txt file - difficult format in QlikView

Import txt file - difficult format

Re: Import txt file - difficult format