Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Import txt file - difficult format

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

QV Transform.JPG

View solution in original post

1 Reply
Not applicable
Author

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

QV Transform.JPG