topic Re: table automatially copied in data model? in Qlik NPrinting

table automatially copied in data model?

ronaldwang — Tue, 29 Aug 2017 02:05:22 GMT

In what circumstance, the qlikview will automatically add some table to your datamart. with a after-fix of "-1". during the process I did not reload the data but I noticed all of a sudden my file size increase a lot and then I found out a few tables have been duplicated in my data model, any idea?

Re: table automatially copied in data model?

Lech_Miszkiewicz — Tue, 29 Aug 2017 04:52:43 GMT

there is many circumstances:

you may be loading from files with * (asterix)
you could have added more files to source folder
you may not be dropping table somewhere
you may want to force concatenate (rather than autoconcatenate)
you may have copied script in 2 places.

Without looking at your script it is difficult to say.

On top of that I hope you have used script editor (not datamodeler in qliksense) to build your script ,because then there should be some logic applied on script.

If you used datamodeler - autogenerated script may not work the way you think it should.

Qlik at the end is not as easy as it seems and you still need to know what you are doing in your script.

I suggest you attach your application so we can have a look at script to help you with this.

cheers

Lech

Re: table automatially copied in data model?

jonathandienst — Tue, 29 Aug 2017 05:01:18 GMT

If you do not specify a name for the table, QV will pick a name based on the source file name or source table. If you load multiple files with the same name (say multiple sheets from a single spreadsheet / multiple loads from a database table or function with different filters / etc), then QV will concatenate the loads if the field list is identical, but will add a new table with a -1 extension if the field lists differ.