topic loading data in QlikView

loading data

bilionut — Thu, 04 Aug 2011 12:08:30 GMT

Hi everybody,

I am very, very new in Qlik also in programming so please heave mercy 🙂

I have two table

table1:

val1, dep

12 , aa

123, aa

223, bb

233, cc

table2:

dep, val2, val3

aa, 122, 3939

bb, 124, 3439

cc, 123, wee9

ee, 344, 3ejej

xx, 556, 3lkm

I need to load data from table2 only if val1=xxx

Thanks a lot

loading data

SunilChauhan — Thu, 04 Aug 2011 12:12:54 GMT

i am not understand clearly but u can try it

table1:

load * inline [

val1, dep

12 , aa

123, aa

223, bb

233, cc

];

table2:

load * inline [

dep, val2, val3

aa, 122, 3939

bb, 124, 3439

cc, 123, wee9

ee, 344, 3ejej

xx, 556, 3lkm

];

Load

dep, val2, val3

resisent tabe2 where dep='XX';

drop table table2;

loading data

bilionut — Thu, 04 Aug 2011 12:18:28 GMT

i want to put condition for field "val1" from table1

loading data

SunilChauhan — Thu, 04 Aug 2011 12:21:23 GMT

but there is no item like xxx in var1

loading data

bilionut — Thu, 04 Aug 2011 12:27:26 GMT

sorry, you have right

condition is something like this: val1=223

loading data

SunilChauhan — Thu, 04 Aug 2011 12:47:36 GMT

table1:

load * inline [

val1, dep

12 , aa

123, aa

223, bb

233, cc

];

table2:

load * inline [

dep, val2, val3

aa, 122, 3939

bb, 124, 3439

cc, 123, wee9

ee, 344, 3ejej

xx, 556, 3lkm

];

Tab3:

Load

dep,

val1 as val1_new

resident table1;

left join

Load

dep,

val2, val3

resisent tabe2 ;

Tab4:

Load

dep,

val2, val3

resident Tab3 where val1_new=123;

drop tables table2, Tab3;

loading data

bilionut — Thu, 04 Aug 2011 13:23:53 GMT

i run this:

table1:

load * inline [

val1, dep

12 , aa

123, aa

223, bb

233, cc

];

table2:

load * inline [

dep, val2, val3

aa, 122, 3939

bb, 124, 3439

cc, 123, wee9

ee, 344, 3ejej

xx, 556, 3lkm

];

Tab3:

Load

dep,

val1 as val1_new

resident table1;

left join

Load

dep,

val2, val3

resident table2 ;

Tab4:

Load

dep,

val2, val3

resident Tab3 where val1_new=123;

drop tables table2, Tab3;

but the result is only table1. If i comment drop tables i dont see tab4

loading data

Anonymous — Thu, 04 Aug 2011 14:37:28 GMT

Hi guy,

When you create your table 4, you give the same name for the column than table 2. Qlikview will automatically join table 2 et table 4 because of that.

you have to understand how QlikView store data in its model. Each time that you have 2 table with exactly the same column names then QlikView will automatically aggregate data and he will create only one table.

i think that there is a command like noconcatenate if you want to see your table 4, try this :

Tab4:

noconcatenate Load

dep,

val2,

val3

resident Tab3 where val1_new=123;

loading data

bilionut — Fri, 05 Aug 2011 06:10:20 GMT

Thanks, it works.