Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I've a problem.Can you help me please.
I've a table
Clomn1(Policy) Clomn2 (ID)
XX 111
YY 111
ZZ 222
MM 222
How can we do the following table?
Clomn2(ID) Clomn1(Policy)
111 XX-YY
222 ZZ-MM
thank you so much...
Here you go
Front End
Concat([Clomn1(Policy)],'-')
In Script
LOAD Concat([Clomn1(Policy)],'-') as Col1 , [Clomn2 (ID)] as Col2 Group By [Clomn2 (ID)];
LOAD * Inline [
Clomn1(Policy), Clomn2 (ID)
XX , 111
YY , 111
ZZ , 222
MM , 222
];
Here you go
Front End
Concat([Clomn1(Policy)],'-')
In Script
LOAD Concat([Clomn1(Policy)],'-') as Col1 , [Clomn2 (ID)] as Col2 Group By [Clomn2 (ID)];
LOAD * Inline [
Clomn1(Policy), Clomn2 (ID)
XX , 111
YY , 111
ZZ , 222
MM , 222
];
Like this
T1:
LOAD * Inline [
Policy , ID
XX ,111
YY ,111
ZZ ,222
MM ,222
];
NoConcatenate
T2:
LOAD
Concat(Policy,'-') as Policy,
ID
Resident T1 Group by ID;
DROP Table T1;
Thank you so much Anil
have a nice day
Thank you so Mahesh
have a nice day