topic Re: Deleting a data file. in QlikView

Deleting a data file.

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to delete a data file, but where I expected to see the trashcan it says the file was created by a script. How do I delete it?

Re: Deleting a data file.

vishsaggi — Mon, 24 Apr 2017 20:33:21 GMT

Can you elaborate and send us a screenshot you having issues with?

Re: Deleting a data file.

Mon, 24 Apr 2017 22:41:28 GMT

I had a loaded file. I wanted to load a new file with updated data. I thought I had deleted the first file and then I loaded the new file. Now, I have two files and an automatic join. I just want to get rid of all the data. I looked in the data model viewer and don't see any way to delete the files.

Re: Deleting a data file.

ahaahaaha — Tue, 25 Apr 2017 06:16:16 GMT

Hi Jerry,

If I understand you correctly, you should help

DROP Table TABLENAME,

where TABLENAME is the name of the table that you see in Table Viewer and which you want to delete.

Regards,

Andrey

Re: Deleting a data file.

vishsaggi — Tue, 25 Apr 2017 12:00:26 GMT

Are you storing your files anywhere? I mean do you want to store the first file somewhere as QVD and load your second file. As Andrey mentioned you can use DROP command. But if you do not want the first file to be loaded, just comment or delete the whole script and just reload the LOAD script that has updated info.

Re: Deleting a data file.

Tue, 25 Apr 2017 12:20:14 GMT

Thank you Vishwarath. So far in my Qlik experience, I have built a very nice app by drag-and-drop. But I have not learned scripts. I don’t know where to put the DROP command. The first file is of no value. If I could clear out both files, then I would reload the good file. So I don’t know the internals (script) where they are or how they function. Jerry

Re: Deleting a data file.

vishsaggi — Tue, 25 Apr 2017 13:46:13 GMT

Are you working on Qlik or QlikSense? Can't view your jpg file attached. They are blank. Can you share a sample qvw file if it is Qlikview?

Re: Deleting a data file.

awhitfield — Tue, 25 Apr 2017 14:08:45 GMT

Hi Jerry,

this sounds like Qlik Sense?

Andy

Re: Deleting a data file.

Tue, 25 Apr 2017 14:10:39 GMT

I’m working with Qlik Sense

Re: Deleting a data file.

Tue, 25 Apr 2017 14:11:51 GMT

Yes, it is QLIK Sense

Re: Deleting a data file.

vishsaggi — Tue, 25 Apr 2017 14:22:28 GMT

We cant see the images they are blank. Don't know why. And also can you post this in QlikSense or change the discussion tag to QlikSense for faster response. You can repost this here:

Qlik Sense Forums

Re: Deleting a data file.

awhitfield — Tue, 25 Apr 2017 14:27:08 GMT

Hi Jerry,

you can move your post to a Qlik Sense forum:

Use the MOVE option under actions on the right of the screen.

Andy