creating 1 table from 2 tables

[#1]

hi,

I have the following:

TABLE1:

ID	PERSON
1	JOHN
2	JACK
3	PAUL
4	PETER

and TABLE2:

ID	MOVIE
1	ABC
1	DEF
2	GHI
2	JKL

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

Thanks,

[senpradip007 · Accepted solution]

Try this:

A:

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]

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