topic Re: script logic in QlikView

script logic

Thu, 04 Aug 2016 10:11:29 GMT

I have two tables Table 1 and Table 2:

Table 1

2010

2011

2012

2013

Table 2

2010

2011

2012

2013

I want out put table using these 2 tables :

OUT PUT Table
AY	CY
2010	2010
2010	2011
2010	2012
2010	2013
2011	2011
2011	2012
2011	2013
2012	2012
2012	2013
2013	2013

Re: script logic

Thu, 04 Aug 2016 18:00:56 GMT

Maybe:

[Table 1]:

LOAD * Inline [

2010

2011

2012

2013

];

[Table 2]:

LOAD * Inline [

2010

2011

2012

2013

];

Table_output:

LOAD * ,RowNo() as Linha Resident [Table 1]; DROP Table [Table 1];

Join(Table_output)

LOAD * , RowNo() as Linha Resident [Table 2]; DROP Table [Table 2];

Re: script logic

sunny_talwar — Thu, 04 Aug 2016 18:18:07 GMT

May be like this:

Table:

LOAD * INLINE [

2010

2011

2012

2013

];

Left Join (Table)

LOAD * INLINE [

2010

2011

2012

2013

];

FinalTable:

NoConcatenate

LOAD AY,

Where Flag = 1;

LOAD AY,

CY,

If(CY >= AY, 1, 0) as Flag

Resident Table;

DROP Table Table;

Re: script logic

Thu, 04 Aug 2016 19:53:15 GMT

if you got a correct answer to check that the community be organized thanks!

Re: script logic

Thu, 04 Aug 2016 20:13:28 GMT

Only do have to use Outer join

[Table 1]:

LOAD * Inline [

2010

2011

2012

2013

];

Outer Join

[Table 2]:

LOAD * Inline [

2010

2011

2012

2013

];

And will you obtain this table: