Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?