Cell value about

[mert1917]

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...

[Anil_Babu_Samineni · Accepted solution]

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

];

[qlikview979]

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;

[mert1917]

Thank you so much Anil

have a nice day

[mert1917]

Thank you so Mahesh

have a nice day