Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to load two cross-tables in at a time in qliksense

Hi,

How to load two crosstables in at a time for example like this:

CrossTable(questions,statement,13)

column1,

column2,

column3,

column4,

CrossTable(questions,statement,4)

column17,

column18,

column20,

column21,

how can i load the different questions in two cross-table along with how to concatenate the cross-tables

Thanks,

Suresh

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Arul,

earlier function is working thanks,

Now,

Table1:

CrossTable(questions,statement,13)

column1,

column2,

column3,

column4,

Table2:

CrossTable(Channel,Channelname,4)

column17,

column18,

column20,

column21,

Earlier both tables have the same field names, now its different i want to load the different table in load editor is this possible can you please help on this.

View solution in original post

7 Replies
arulsettu
Master III
Master III

Maybe like this

Table1:

CrossTable(questions,statement,13)

column1,

column2,

column3,

column4,

Table2:

CrossTable(questions,statement,4)

column17,

column18,

column20,

column21,

NoConcatenate 

   

temp:  

load *  Resident Table1;

Concatenate

 

load * Resident Table2;

drop Table Table1;

drop Table Table2;

Anonymous
Not applicable
Author

Hi Arul,

Exactly same thanks,

Regards,

Suresh.

arulsettu
Master III
Master III

is it working?

Anonymous
Not applicable
Author

Yes arul

arulsettu
Master III
Master III

can you close the thread and mark my suggestion as correct

Anonymous
Not applicable
Author

Arul i am in new in this community how to close the threat

Anonymous
Not applicable
Author

Hi Arul,

earlier function is working thanks,

Now,

Table1:

CrossTable(questions,statement,13)

column1,

column2,

column3,

column4,

Table2:

CrossTable(Channel,Channelname,4)

column17,

column18,

column20,

column21,

Earlier both tables have the same field names, now its different i want to load the different table in load editor is this possible can you please help on this.