Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
mert1917
Contributor III
Contributor III

Cell value about

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

];


Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

4 Replies
Anil_Babu_Samineni

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

];


Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
qlikview979
Specialist
Specialist

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
Contributor III
Contributor III
Author

Thank you so much Anil

have a nice day

mert1917
Contributor III
Contributor III
Author

Thank you so Mahesh

have a nice day