script logic

[#1]

I have two tables Table 1 and Table 2:

Table 1

AY

2010

2011

2012

2013

Table 2

CY

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

[#2]

Maybe:

[Table 1]:

LOAD * Inline [

AY

2010

2011

2012

2013

];

[Table 2]:

LOAD * Inline [

CY

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];

[sunny_talwar]

May be like this:

Table:

LOAD * INLINE [

      AY

    2010

    2011

    2012

    2013

];

Left Join (Table)

LOAD * INLINE [

  CY

    2010

    2011

    2012

    2013

];

FinalTable:

NoConcatenate

LOAD AY,

  CY

Where Flag = 1;

LOAD AY,

  CY,

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

Resident Table;

DROP Table Table;

[#4]

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

[#5]

Only do have to use Outer join

[Table 1]:

LOAD * Inline [

AY

2010

2011

2012

2013

];

Outer Join

[Table 2]:

LOAD * Inline [

CY

2010

2011

2012

2013

];

And will you obtain this table: