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

How to Concatenate between 2 String Fields in Script?

khasimvali85 — Fri, 04 Jul 2014 04:37:03 GMT

Hi,

Between Two fields how to do Concatenate in Script?

anybody Could give the solution?

Thanks,

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

Fri, 04 Jul 2014 04:37:54 GMT

say

Load

Field1 & '-' & Field2

...

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

VishalWaghole — Fri, 04 Jul 2014 04:38:37 GMT

Try this,

Field1 &'-'& Field2 as NewField

this will concatenate with - .

Thanks

Vishal

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

khasimvali85 — Fri, 04 Jul 2014 04:38:56 GMT

Hi,

Same Thing i given but its not working

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

er_mohit — Fri, 04 Jul 2014 04:45:16 GMT

use autonumberhash function to make concatenate field with unique integer

like below used in both table

autonumberhash128(Field1,Field2) as Key

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

Anonymous — Fri, 04 Jul 2014 04:49:29 GMT

Hi,
Try concatenating the fields in resident table..

HTH

ravi N.

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

khasimvali85 — Fri, 04 Jul 2014 04:51:18 GMT

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?

its_anandrjs — Fri, 04 Jul 2014 04:54:10 GMT

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?

its_anandrjs — Fri, 04 Jul 2014 04:57:07 GMT

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.

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

khasimvali85 — Tue, 08 Jul 2014 05:51:32 GMT

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.

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

tresB — Tue, 08 Jul 2014 06:00:53 GMT

If you want to refer another table from one table in the script, you have to use JOIN or ApplyMap. Please learn about these from help.