topic Re: creating 1 table from 2 tables in QlikView

creating 1 table from 2 tables

Fri, 20 Sep 2013 13:07:46 GMT

hi,

I have the following:

TABLE1:

and TABLE2:

I need all the information to be in TABLE1 in a flat structure. Is there a way to do this in qlikview?

Thanks,

senpradip007 — Fri, 20 Sep 2013 13:19:01 GMT

Try this:

LOAD * Inline [
Idd,Person
1,Peter
2,John
3,Karb
4,Bob
];
Left Join
LOAD * Inline [
Idd,Movie
1,ABC
1,DEF
2,GHI
2,JKL
];

hic — Fri, 20 Sep 2013 21:26:37 GMT

Why do you need it in a flat structure? Most calculations work just as well, if not better, if you keep it in two tables. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join

HIC