Import txt file - difficult format

[#1]

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.

[#2 · Accepted solution]

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