topic Re: Concatenate table without empty rows in QlikView

Concatenate table without empty rows

jsobrinho — Sat, 16 Nov 2024 19:24:43 GMT

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?

Re: Concatenate table without empty rows

Taoufiq_Zarra — Fri, 20 Dec 2019 14:43:14 GMT

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;

Re: Concatenate table without empty rows

Brett_Bleess — Thu, 26 Dec 2019 15:23:53 GMT

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

Re: Concatenate table without empty rows

jsobrinho — Fri, 27 Dec 2019 10:08:32 GMT

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