topic Re: How to apply KEEP on a Cross table in QlikView

How to apply KEEP on a Cross table

ritvik4BI — Mon, 01 Mar 2021 14:28:17 GMT

Hi everyone,

I am stuck here and need some help on this.

I have two tables Table1 and Table2 and I am trying to apply a LEFT KEEP keeping in mind that I want to keep the complete Table1 and only the common fields in Table2. But the thing is that Table2 is a cross table. So when I apply keep before Table2, it throws me an error. The thing is I cant even take resident or make a qvd of Table2 because Table2 has tens of thousands of columns and that puts unnecessary load on my server. So how to go about things here?

Thanks

Re: How to apply KEEP on a Cross table

Saravanan_Desingh — Mon, 01 Mar 2021 18:08:58 GMT

Please check @edwin 's response here

https://community.qlik.com/t5/QlikView-App-Dev/How-to-apply-KEEP-on-a-Cross-table/td-p/1787164

Re: How to apply KEEP on a Cross table

edwin — Mon, 01 Mar 2021 21:46:00 GMT

a couple of comments: your crosstable syntax may not work tag should also be in the load
10s of thousands of records is very small unless you have thousands of columns

having said that maybe what you want is to do an exists function in the where clause instead of a keep. this way you dont need to do a resident load.