topic Re: concatenate in QlikView

concatenate

Thu, 13 Nov 2014 09:23:29 GMT

Hello guys,

can you please tell me how to use concatenate and which script i have use for concatenating 2 cols??

plese give me answer

Re: concatenate

vardhancse — Thu, 13 Nov 2014 09:24:45 GMT

for joining 2 fields we can add one resident load for the table we loaded and can drop the table:

Table_1:

LOAD * INLINE [Field_1, Field_2

A,User_1

B,User_2

];

Noconcatenate

Table_2:

LOAD

(A & '-' & B) as C

From resident Table_1;

Drop table Table_1;

Re: concatenate

vardhancse — Thu, 13 Nov 2014 09:27:46 GMT

For concatenating tables:

ABC:

LOAD * INLINE [Field_1,Field_2

A,Name

B,Author

];

Concatenate

LOAD * INLINE [Field_1,Field_3

A,USA

B,UK

];

Re: concatenate

ashwanin — Thu, 13 Nov 2014 09:34:08 GMT

Hi Vishnupriya,

Lets you have 2 columns named WO & Date respectively. Now you want to concatenate this then you have to write like this :

Load

WO,

Date,

WO &'-'& Date as WODate

from xxx ;

Re: concatenate

amit_saini — Thu, 13 Nov 2014 09:37:41 GMT

Please see this:

Understanding Join, Keep and Concatenate

Thanks,
AS

Re: concatenate

ashfaq_haseeb — Thu, 13 Nov 2014 09:51:03 GMT

Hi,

Check this

QlikView Joins

Regards

ASHFAQ

Re: concatenate

Thu, 13 Nov 2014 10:01:28 GMT

Dear vishnu,

in qv we have 3 types of concatenation

1)concatenation

2)no concatenation

3)automatic conctenation

concatenation:

when we want to combine the tables if the fields are also not same then we go for this

noconcatenation:

when field are same and we want avoid the combining tables (due to unwantedly getting syn keys) we go for noconcatenation.

autoconcatenation:

when we have fields are same in both tables then qlikview it self goes for automatic concatenation.

ex:

load

from table1;

concatenation //noconcatenation//autoconcatenatio

load

from table2;

make sure pls close the thread by making apporopriate answer

Re: concatenate

Thu, 13 Nov 2014 10:40:42 GMT

sir how to use string functions in script??

where it can be placed??

Re: concatenate

Thu, 13 Nov 2014 10:43:06 GMT

dear priya ,

make this thread close and raise another one.

kotha question ga adagani and e question close cheyandi pls....

Re: concatenate

vardhancse — Thu, 13 Nov 2014 10:46:49 GMT

u can get in detail in qlikview help (f1)about string function.

You can close this thread if it helps.

Re: concatenate

Thu, 13 Nov 2014 13:01:52 GMT

Hi Priya,

Concatenate tables like Union in Oracle.it will append the records from both tables like vertival merging.

Tab1:

Load * from tab1;

Concatenate

Load * from tab2;

But here two tables having same structure.

concatenation: if you dont have same structure use concatenate keyword.if you have same structure qlikview itself it will concatenate each other by default.

noconcatenation: if you don't want concatenation use no concatenate keyword

Column concatenation means if you have A and B columns then create new column like this

Load A,

A&' '&B as New_Column( this is field concatenation)

from table;

hope this will help to you.

Re: concatenate

Thu, 13 Nov 2014 13:03:37 GMT

Hi Priya,

Just goto ---> qlikview Help der all the string functions are der.just go through that if you dont understand any function just post it in community.

der you can find all the string and numeric and time functions