How to Concatenate between 2 String Fields in Script?

[khasimvali85]

Hi,

Between Two fields how to do Concatenate in Script?

anybody Could give the solution?

Thanks,

[#2]

say

Load

Field1 & '-' & Field2

...

[VishalWaghole]

Try this,

Field1 &'-'& Field2 as NewField

this will concatenate with - .

Thanks

Vishal

[khasimvali85]

Hi,

Same Thing i given but its not working

[er_mohit]

use autonumberhash function to make concatenate field with unique integer

like below used in both table

autonumberhash128(Field1,Field2) as Key

[Anonymous]

Hi,
Try concatenating the fields in resident table..

HTH

ravi N.

[khasimvali85]

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

[its_anandrjs]

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

[its_anandrjs]

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]

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.