Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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;
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
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