Consider two tables with a 1-to-n relationship. Table A has one row and 40 columns. Table B has 100 rows and 20 columns. Only 10 of the 100 rows are related to the row in Table A.
Is there a way to eliminate the 90 rows from Table B that aren't related to Table A in the Data Manager or Data Load Editor without using the JOIN function? I don't want to duplicate the columns of Table A n times.
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
