Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikview experts,
Where we can use NoConcatenate in qlikview . please give an example.
thanks in advance.
Hi,
Generally Qlikview will Autoconcatenate if the columns in both the tables are same. To avoid this we need to Noconcatenate option.
Let us try with an example
Without NoConcatenate:
Data:
LOAD
*
INLINE [
Value1, Value2
A, 100
b, 200];
Data1:
LOAD
*
INLINE [
Value1, Value2
A, 100
b, 200];
Both tables Data and Data1 are merged into a single table Data.
With NoConcatenate:
Data:
LOAD
*
INLINE [
Value1, Value2
A, 100
b, 200];
Data1:
NoConcatenate
LOAD
*
INLINE [
Value1, Value2
A, 100
b, 200];
Now two tables will be created.
Hope this helps you in understanding the concepts.
Regards,
Jagan.
TTT:
Load A,B,C Resident Tab1;
ZZZ:
noconcatenate
Load * resident TTT;
left join
Load * resident Table999;
Drop table TTT;
Without noconcatenate the drop would delete even the table ZZZ
Hi,
Generally Qlikview will Autoconcatenate if the columns in both the tables are same. To avoid this we need to Noconcatenate option.
Let us try with an example
Without NoConcatenate:
Data:
LOAD
*
INLINE [
Value1, Value2
A, 100
b, 200];
Data1:
LOAD
*
INLINE [
Value1, Value2
A, 100
b, 200];
Both tables Data and Data1 are merged into a single table Data.
With NoConcatenate:
Data:
LOAD
*
INLINE [
Value1, Value2
A, 100
b, 200];
Data1:
NoConcatenate
LOAD
*
INLINE [
Value1, Value2
A, 100
b, 200];
Now two tables will be created.
Hope this helps you in understanding the concepts.
Regards,
Jagan.