Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist III
Specialist III

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
Specialist III
Specialist III

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
Specialist
Specialist

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
Master III
Master III

Please see this:

Understanding Join, Keep and Concatenate

Thanks,
AS

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this

QlikView Joins

Regards

ASHFAQ

Not applicable
Author

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
Author

sir how to use string functions in script??

      where it can be placed??

Not applicable
Author

dear priya ,

make this thread close and raise another one.

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

vardhancse
Specialist III
Specialist III

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

You can close this thread if it helps.