Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
khasimvali85
Contributor II

How to Concatenate between 2 String Fields in Script?

Hi,

Between Two fields how to do Concatenate in Script?

anybody Could give the solution?

Thanks,

Tags (1)
10 Replies
Not applicable

Re: How to Concatenate between 2 String Fields in Script?

say

Load

Field1 & '-' & Field2

...

vishalwaghole
Valued Contributor II

Re: How to Concatenate between 2 String Fields in Script?

Try this,

Field1 &'-'& Field2 as NewField

this will concatenate with - .

Thanks

Vishal

khasimvali85
Contributor II

Re: How to Concatenate between 2 String Fields in Script?

Hi,

Same Thing i given but its not working

er_mohit
Honored Contributor II

Re: How to Concatenate between 2 String Fields in Script?

use autonumberhash function to make concatenate field with unique integer

like below used in both table

autonumberhash128(Field1,Field2) as Key

ravic906
Contributor III

Re: How to Concatenate between 2 String Fields in Script?

Hi,
Try concatenating the fields in resident table..

HTH

ravi N.

khasimvali85
Contributor II

Re: How to Concatenate between 2 String Fields in Script?

Hi,

These two fields are diff. table fields

Ex:

Tab1:

load

Brand,

Product,

Organization

From

D:\Users\Service\BrandProduct.xlsx

Tab2:

Zone,

ASC_ID

from

D:\Users\Service\Organization.xlsx

Re: How to Concatenate between 2 String Fields in Script?

I believe this could worked Field1 & '-' & Field2

See the load script

Load First,Last, First & '-' & Last as FirstnLast;

Load * Inline

[

First,Last

John, Bosco

Margarate, Desousa

];

Out Put:-

John-Bosco

Margarate-Desousa

Re: How to Concatenate between 2 String Fields in Script?

By this model you concatenate the fields in the front end in any chart

Ex:-

Zone & '-' & Product


If you want to do that in any script then two tables are in one table then you are able to do that.

khasimvali85
Contributor II

Re: How to Concatenate between 2 String Fields in Script?

Hi,

It Works Thanks for Suggession,

but i need exact out put

I have Fields like Organization, Zone then i want to concatenate these fields given below

Organization

AC,

CLR,

KENSTAR,

SAN+KEL,

OTHER

VIDEOCON

Zone

Focus India

Greater India

i given like this Organization &'  '& Zone  as Organization

But My OutPut is like below

Organization

AC,

CLR,

Focus India

KENSTAR,

Greater India SAN+KEL,

OTHER

Greater India VIDEOCON

i used if condition also but not show exact out put

Any Suggession

Regards,

Khasim.

Community Browser