Discussion Board for collaboration on QlikView Scripting.
I have two tables Table 1 and Table 2:
I want out put table using these 2 tables :
LOAD * Inline [
LOAD * ,RowNo() as Linha Resident [Table 1]; DROP Table [Table 1];
LOAD * , RowNo() as Linha Resident [Table 2]; DROP Table [Table 2];
May be like this:
LOAD * INLINE [
Left Join (Table)
Where Flag = 1;
If(CY >= AY, 1, 0) as Flag
DROP Table Table;
if you got a correct answer to check that the community be organized thanks!
Only do have to use Outer join
And will you obtain this table: