Concatenate table without empty rows

[jsobrinho]

Hi guys, 

I have two tables: 

Table A

Colum A

Table B

Colum B

I need to concatenate these two tables, but I need to remove the rows empty on the final table, it's possible?

[Taoufiq_Zarra]

Colum A empty and Colum B not empty or Colum B empty and Colum A?
because Colum A and Colum B are empty simultaneously will not be the case

if that's the case try this:

TableA:
load 
ColumA
...
concatenate
TableB:
load
columB
..

Result:
Noconcatenate
load
ColumA,
columB
resident TableA
WHERE Len(Trim(columA))>0
and Len(Trim(columB))>0
;
drop table tableA;

[Brett_Bleess]

Did Taoufiq's proposed solution work for you use case?  If so, do not forget to return to your thread and use the Accept as Solution button on his post to give him credit for the assistance and to let other Community Members know it worked.  If you still require further assistance, leave an update post.

The only other thing I can provide is the base URL to the Design Blog area of Community, which contains hundreds of mostly how-to posts related to the different products written by our internal experts that may help you with further ideas.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[jsobrinho · Accepted solution]

Thank you everybody

I solved my problem:

I created the RowNo() field, and after creating an outer join between two tables, so I don't have more column with empty lines