How to apply KEEP on a Cross table

ritvik4BI — Mon, 01 Mar 2021 17:26:03 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?

The script I am using is something like this:

Table1:
LOAD MachineID,
TagID,
TagName
FROM
[Scenario.xlsx]
(ooxml, embedded labels, table is Sheet1);

left keep
Table2:
CrossTable(TagName, Data)
LOAD timestamp,
Alpha,
Beta,
Gamma,
x,
y,
z
FROM
[Scenario.xlsx]
(ooxml, embedded labels, table is Sheet2);

exit script;

Note: Table2 has tens of thousands of columns so aplha,beta, gamma, x,y and z are just an example hence I can not take a resident or make a qvd because of too much load on the server. And I want the complete Table1 and only the common columns from Table2 like alpha,beta and gamma in this case. So is there any way via which I can apply KEEP with CrossTable?

Thanks and Regards.

Re: How to apply KEEP on a Cross table

edwin — Mon, 01 Mar 2021 17:58:36 GMT

you cant apparently CANT apply a keep and a cross at the same time. you may have to create a 3rd table:

table1:..... table2: crosstable ..... noconctenate Table3: left keep (table1) load * table2; drop table table2;

topic How to apply KEEP on a Cross table in QlikView

How to apply KEEP on a Cross table

Re: How to apply KEEP on a Cross table