Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hil_boy99
Contributor II
Contributor II

Semi-Structured .txt File Load

I have a text file that has data in a semi structured way but I cannot work out how to load this into QV.

I want to end up with a QV file which shows values for S for each type of X and Y

Attached is the (shortened)  text text file for two different products ProdName1 and ProdName2 or two different regions

Office1 an Office 2.

I was going OK on setting up the headers and using @1 through to @33 but then the wheels fell off and I just ended up in a mess.

Can anyone point me in the right direction of what I need to do?

Many thanks

Hil

4 Replies
qlikviewwizard
Master II
Master II

What is expected output of the data?

hil_boy99
Contributor II
Contributor II
Author

Hi I need it so that each value of S has a value for each value of X and Y.

If I have transposed it correctly, it should look like this

S,X,Data,Y,Data

0,0,2,0,

0,-0.25,1,-0.25,

0,-0.5,,-0.5,

0,-0.75,,-0.75,

0,-1,3,-1,

0,-1.25,1,-1.25,

0,-1.5,6,-1.5,

0,-1.75,,-1.75,

0,-2,3,-2,

0.25,0,0,0,1

0.25,-0.25,0,-0.25,1

0.25,-0.5,1,-0.5,

0.25,-0.75,,-0.75,1

0.25,-1,,-1,2

0.25,-1.25,,-1.25,

0.25,-1.5,,-1.5,1

0.25,-1.75,1,-1.75,

0.25,-2,,-2,

0.5,0,,0,6

0.5,-0.25,,-0.25,2

0.5,-0.5,6,-0.5,2

0.5,-0.75,,-0.75,

0.5,-1,,-1,3

0.5,-1.25,,-1.25,0

0.5,-1.5,,-1.5,1

0.5,-1.75,1,-1.75,

0.5,-2,,-2,

qlikviewwizard
Master II
Master II

Can you show me in the picture?

Capture.PNG

hil_boy99
Contributor II
Contributor II
Author

Hmm not sure how to do that.
Put it another way, I want the values for each column and for each line.
So my first value (which is 0,0) will have a value of 2.
My next value (0, -0.25) has a value of 1

After that (0,-0.5) has null value.
Does that make sense?