Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

concatenate

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

11 Replies
vardhancse
Valued Contributor II

Re: concatenate

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;

vardhancse
Valued Contributor II

Re: concatenate

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

];

ashwanin
Valued Contributor

Re: concatenate

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 ;

amit_saini
Honored Contributor III

Re: concatenate

Please see this:

Understanding Join, Keep and Concatenate

Thanks,
AS

Re: concatenate

Hi,

Check this

QlikView Joins

Regards

ASHFAQ

Highlighted
Not applicable

Re: concatenate

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

Not applicable

Re: concatenate

sir how to use string functions in script??

      where it can be placed??

Not applicable

Re: concatenate

dear priya ,

make this thread close and raise another one.

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

vardhancse
Valued Contributor II

Re: concatenate

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

You can close this thread if it helps.