Home > Software > QlikView
Interview Questions   Tutorials   Discussions   Programs   Videos   

QlikView - Explain NoConcatenation?




2003
views
asked SRVMTrainings February 18, 2015 08:23 PM  

Explain NoConcatenation?


           

4 Answers



 
answered By Sathish Etukala   0  
if you have two tables like bellow
EMP:

ENO ENAME SAL
1 A 100
2 B 101
4 C 102
EMP2:

ENO ENAME SAL
3 D 110
5 E 120
6 F 130
you can load these two table qlikview automatically taken two tables one table,

in that time we use noconcatenate key word then qlikview load two tables differently.

regards
s reddy 
flag   
   add comment

 
answered By   0  

LOAD EmpID, EmployeeName, Region, Name, Deptno FROM [C:\Users\sanvi\Desktop\qlickview\Source\Excel\Employee.xls] (biff, embedded labels, table is Employees$); NOConcatenate LOAD EMPID, ENAME, SAL, DEPTNO FROM [C:\Users\sanvi\Desktop\qlickview\Source\Excel\Employee.xls] (biff, embedded labels, table is Sheet2$); NoConcatenate LOAD A, B FROM [C:\Users\sanvi\Desktop\qlickview\Source\Excel\Employee.xls] (biff, embedded labels, table is Sheet4$);

The NoConcatenate prefix forces two loaded tables with identical field sets to be treated as two separate internal tables, when they otherwise would be automatically be concatenated.

The syntax is

flag   
   add comment

 
answered By   0  

Prevents Concatenation from automatic concatenation .

flag   
   add comment

 
answered By SRVMTrainings   0  
if the two tables have same fields also NoConcatenate treats as separate internal tables.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert