Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a issue with concatinate like below;
Scenario 1
Qvd1:
A,B
from Qvd1;
Concatinate(Qvd1)
load
C
from Qvd2;
Then I am not able to see C's data - and looks like;A,B,C
1,2,-
4,8,-
Scenario 2
Qvd2:
C
from Qvd2;
Concatinate(Qvd2)
load
A,B
from Qvd1;
Then I am not able to see A,B's data - and looks like;
A,B,C
-,-,Z
-,-,Y
Hi,
You need to spell it as Concatenate
thanks,
Rajesh Vaswani
try this
DIRECTORY;
Qvd1:
load * inline [
A,B
a1,b1
a2,b2
];
Qvd2:
load * inline [
C
c1
c2
];
store Qvd1 into Qvd1.qvd (qvd);
store Qvd2 into Qvd2.qvd (qvd);
DROP Tables Qvd1, Qvd2;
Qvd1:
load A,B from Qvd1.qvd (qvd);
Concatenate (Qvd1)
load C from Qvd2.qvd (qvd);
Still not coming,
TradeDetailForecastQVD:
LOAD IDENT
FROM
(
Concatenate(TradeDetailForecastQVD)
LOAD Trad_LEGAL_ENTITY,
Trad_FTP_ENTITY_CODE
FROM
(
Data is there for all. Even I checked till last.
Priya, hi
the result of the print that you have is the correct,
if you concatenate two tables that any field join with other field you will see like you have now.
you have A, B from q1 and C from qv2, you concatenate and the result is ok, the data that have A and B do not have C, that is correct.
what do you want to do?
please let me know the objetive and the result you want?
Thank you Fernando
see this post that explain concatenate function
http://community.qlik.com/thread/39177
Concatenate and NoConcatenate in QlikView – Part 1 | Learn QlikView
post your data (qvd) or an extract of these
Hi Priya,
you just need to correct spelling.
see below.
Concatenate
could you please attach the qvw?
like Fernando mentioned, the result is correct. if you scroll down enough, you will see the values from other tables as well. but the corresponding fields from the other table will be null as there is no key to associate the two tables data with.
Concatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated table is always the sum of the rows from the two input tables
There has to be a key in order to see the combine results (A being the key in this)
Qvd1:
A,B
from Qvd1;
Concatinate(Qvd1)
load
A,C
from Qvd2;