Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Between Two fields how to do Concatenate in Script?
anybody Could give the solution?
Thanks,
say
Load
Field1 & '-' & Field2
...
Try this,
Field1 &'-'& Field2 as NewField
this will concatenate with - .
Thanks
Vishal
Hi,
Same Thing i given but its not working
use autonumberhash function to make concatenate field with unique integer
like below used in both table
autonumberhash128(Field1,Field2) as Key
Hi,
Try concatenating the fields in resident table..
HTH
ravi N.
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
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
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.
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.