topic Re: Text file into Qlikview in QlikView

Text file into Qlikview

Tue, 24 Jul 2012 13:01:21 GMT

I have the following text files that I need to bring into a qvw. I wasn't sure how to do it.

The format of them is the same and I will be getting a new one every month which means this will have to take from all files with, say, CICS* in the name so I don't have to import the new one every month. All I want to have to do is put the new file in the folder with all of these files.

I need the "DATE", "# of T/XS" and "AVG RSP" column. The last column can be calculated if need be.

I don't need the Totals either. Those can be calculated. Just the raw data.

Please help!

Thanks

Re: Text file into Qlikview

Tue, 24 Jul 2012 13:41:11 GMT

try this:

LOAD @1 as DATE,

@2 as [# of T/XS],

@3 as [AVG RESP]

FROM (txt, codepage is 1250, explicit labels, delimiter is spaces, msq, header is 2 lines) where isnum(@2);

Re: Text file into Qlikview

Tue, 24 Jul 2012 15:05:14 GMT

Can you explain how you got this?

Re: Text file into Qlikview

Tue, 24 Jul 2012 15:12:14 GMT

using qv script wizard (+ some individual modification)

edit script ---> table files ---> (choose your file xls,txt, etc) i choose delimited

then finish

final script i modified by marking file names by * (star) and i add where clause

@1,@2,@3....etc are the column names if you don't want to get embded lebels

Re: Text file into Qlikview

Tue, 24 Jul 2012 15:16:50 GMT

Can I join these all together?

Re: Text file into Qlikview

Tue, 24 Jul 2012 15:31:25 GMT

now i gonna ask you

what you mean by: join these all together?

Re: Text file into Qlikview

Tue, 24 Jul 2012 15:38:00 GMT

Like when you use a Left Join or contatenate to bring all the data into one table instead of having it be in separate tables. Right now each file ends up being in its own table. I want it all in one so I can call, for example, "DATE" field and get all the dates.

Re: Text file into Qlikview

Tue, 24 Jul 2012 15:49:36 GMT

Look at the sample picture. I noticed another problem. Why is April not coming in correctly like the others?

But to my other question, I want them to all appear in one table.

Re: Text file into Qlikview

Tue, 24 Jul 2012 17:23:54 GMT

Here is a sample app with what I currently see.

I want them all in one table. Plus april seems to be doing something funky.

Any help would be great.

Swuehl, where are you when I need you!!!

Re: Text file into Qlikview

Tue, 24 Jul 2012 19:52:18 GMT

//Qualify *;

<--- you dont need this here

F1 help:D

Qualify

The automatic join between fields with the same name in different tables can be suspended by means of the qualify statement, which qualifies the field name with its table name. If qualified, the field name(s) will be renamed when found in a table. The new name will be in the form of tablename.fieldname. Tablename is equivalent to the label of the current table, or, if no label exists, to the name appearing after from in load and select statements.

Qualification is always turned off by default at the beginning of script execution. Qualification of a field name can be turned on at any time using a qualify statement. Qualification can be turned off at any time using an unqualify statement.