How to apply KEEP on a Cross table

[ritvik4BI]

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

[Saravanan_Desingh]

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

[edwin]

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.