topic Re: How to open .dat file, and create QVD/QVW?? in QlikView

How to open .dat file, and create QVD/QVW??

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I am very new to QV, but I would love to learn, and any help is greatly appreciated!

I am interning at a company this summer, and was told that they log stats in .dat files and rely on Qlikview to generate QVDs of the .dat files. Then they write QVW reports using the data in QVDs.

However, since I am so new to this, I have no idea how to even create a QVD, or how to load the dat file correctly into the QV??

This is my screen after dragging in a .dat file into QV, delimited.

Any help at all is appreciated, thanks!

Re: How to open .dat file, and create QVD/QVW??

shiveshsingh — Thu, 27 Apr 2017 15:34:00 GMT

You need to reload the .DAT file by clicking the reload button.

I guess you have loaded the file by cliking on tables button that is present in bottom.

can you please attach the sample file here?

Re: How to open .dat file, and create QVD/QVW??

vishsaggi — Thu, 27 Apr 2017 15:45:06 GMT

When you load this do you see any data?

May be use store command to load this data into QVD.

Table1:

Load @1 AS Fieldname1,

@2 AS FieldName2,

.......

FROM yoursourceFilepath;

Store Table1 INTO YourpathHere\Table1.qvd(qvd);

Drop Table Table1;

Re: How to open .dat file, and create QVD/QVW??

Thu, 27 Apr 2017 15:55:22 GMT

Here is the screen when I drag the .dat file into QV.

I'm thinking it might be the problem with the .dat file? The delimiters arent commas, it seems to be some unreadable ASCII character.

Re: How to open .dat file, and create QVD/QVW??

shiveshsingh — Thu, 27 Apr 2017 16:00:29 GMT

please attach sample data

Re: How to open .dat file, and create QVD/QVW??

Thu, 27 Apr 2017 16:10:02 GMT

Hi Aaron,

See threads below

Importing a .dat file extension file | Qlik Community

Problem to load .dat File | Qlik Community

Warm regards,

Nish

Re: How to open .dat file, and create QVD/QVW??

Thu, 27 Apr 2017 16:18:16 GMT

Here. This is a portion of the .dat file. I can't post all of it, due to confidentiality.

Re: How to open .dat file, and create QVD/QVW??

Thu, 27 Apr 2017 17:58:55 GMT

On File wizard select "Spaces" instead, then manually add labels to the columns containing good/useful data, see screenshot below.

Once this is done you can exclude from load the superfluous columns like @1, @3 by clicking X - this should do the trick for you.

Re: How to open .dat file, and create QVD/QVW??

Thu, 27 Apr 2017 21:17:04 GMT

Hi, thank you so much!

With this, I was able to create a QVD after delimiting the file.

However, how do I create a QVW now? I was told I could create a QVW report of sorts, from the QVD File

Thanks in advance!

Re: How to open .dat file, and create QVD/QVW??

Thu, 27 Apr 2017 22:46:27 GMT

It's my pleasure!

I am sorry I don't understand. A QVW is a QlikView document / application (app)

You can use script function "Store" to create a QVD or CSV file from a QVW.

Store ‒ QlikView

Warm regards,

Nish

Re: How to open .dat file, and create QVD/QVW??

Thu, 27 Apr 2017 23:04:42 GMT

Hi,

I noticed that you have posted your QVW query under a new thread. If you don't mind could you mark my reply as correct and close this thread - this is a way to show your appreciation and is deemed a good practice by Qlik Community

Qlik Community Tip: Marking Replies as Correct or Helpful

Warm regards,

Nish

Re: How to open .dat file, and create QVD/QVW??

Thu, 27 Apr 2017 23:07:23 GMT

Yes, thank you