topic Semi-Structured .txt File Load in QlikView

Semi-Structured .txt File Load

hil_boy99 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Semi-Structured .txt File Load

qlikviewwizard — Thu, 04 Oct 2018 02:31:46 GMT

What is expected output of the data?

Re: Semi-Structured .txt File Load

hil_boy99 — Thu, 04 Oct 2018 02:56:17 GMT

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,

Re: Semi-Structured .txt File Load

qlikviewwizard — Thu, 04 Oct 2018 03:20:03 GMT

Can you show me in the picture?

Re: Semi-Structured .txt File Load

hil_boy99 — Thu, 04 Oct 2018 03:25:25 GMT

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?