topic Re: Several Source files one listbox in QlikView

Several Source files one listbox

Wed, 11 Mar 2015 10:42:49 GMT

I have like 3 Fact tables (no join/concanate) and for each of them I have a "bla bla AS Source..", so I end up with Source A, Source B, Source C, but the content is the same and there is several choices that the user needs to choose from.

At the front-end I need to put them together so the user only have one listbox, "one set of content". I cannot see how the concat can help here.

What is the correct solution for this? and of course I am concerned that the datamodel still work.

Re: Several Source files one listbox

Gysbert_Wassenaar — Wed, 11 Mar 2015 10:49:34 GMT

so I end up with Source A, Source B, Source C, but the content is the same

Then you should concatenate those fact tables:

FactTable:

LOAD *, 'Source A' as Source FROM SourceA;

concatenate(FactTable)

LOAD *, 'Source B' as Source FROM SourceB;

concatenate(FactTable)

LOAD *, 'Source C' as Source FROM SourceC;

Re: Several Source files one listbox

puttemans — Wed, 11 Mar 2015 11:10:03 GMT

If only the content of the source-variable is the same,and not the whole fact table, then you load all tables, and just rename the Source variable in all 3 with the same name, without concatenating

Re: Several Source files one listbox

Wed, 11 Mar 2015 11:57:23 GMT

thx but then I get loops, as they are linked via other fields.

Re: Several Source files one listbox

Wed, 11 Mar 2015 12:00:23 GMT

Thx but I dont want to concatenate or join them.

Re: Several Source files one listbox

Gysbert_Wassenaar — Wed, 11 Mar 2015 12:36:25 GMT

Why do you not want to concatenate them? What is the business requirement that you think cannot be met if you do concatenate the tables?

Re: Several Source files one listbox

puttemans — Wed, 11 Mar 2015 13:01:22 GMT

Then you 'qualify' each table. Looking at your request however, I don't see why you would not concatenate all 3 tables if they have all three the same information or the same fields. By concatenating, you won't lose any data, the program just puts all three tables together. Look at it as putting data from 3 separate excell sheets into one sheet. You won't lose any columns, your number of rows get bigger.

If possible, then please describe your variables in your 3 tables, and why they should keep separate.

Re: Several Source files one listbox

Wed, 11 Mar 2015 14:22:07 GMT

Hi Mikael,

You will try like this type.

FactTable1:

LOAD *,

A as Source

FROM SourceA;

FactTable2

LOAD *,

B as Source

FROM SourceB;

FactTable3

LOAD *,

C as Source

FROM SourceC;

Thanks,

krish

Re: Several Source files one listbox

Wed, 11 Mar 2015 15:25:21 GMT

Too large and complex, there is a lot of other fields and data.

Re: Several Source files one listbox

Gysbert_Wassenaar — Wed, 11 Mar 2015 16:53:59 GMT

Concatenating fact tables is easy if they contain the same content. Other fields and data shouldn't have any effect on that. But if you think that it cannot be done then perhaps you shouldn't try at all and create three separate documents instead.

Re: Several Source files one listbox

Wed, 11 Mar 2015 18:10:44 GMT

Well I know very well how to concatenate, though my first thought is always too join to avoid double data and add new fields. Why you like concatenate so much?

I already have a reload time beyond 1 hour, so whether I join or concatenate, dont you think it will just make thinks worse?

Re: Several Source files one listbox

Gysbert_Wassenaar — Wed, 11 Mar 2015 18:35:08 GMT

I like concatenate so much only when the tables contain the same content. I don't like making a data model any more complicated then it needs to be. If I can have one fact table instead of three the same content that sounds like a good deal to me. You could well have perfectly fine reasons to not concatenate the fact tables. I just haven't seen or heard anything concrete to tell me you do.