Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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];
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;
if you got a correct answer to check that the community be organized thanks!
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: