Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

];


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
Highlighted

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

];


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

Highlighted
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;

Highlighted
Contributor III
Contributor III

Thank you so much Anil

have a nice day

Highlighted
Contributor III
Contributor III

Thank you so Mahesh

have a nice day