Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Reformating Data Assistance

Hello,

I would like to know how to format the data below.

From

Company Names
ABC
DEF
PQR
XYZ

To
ABC, DEF, PQR, XYZ

Please kind advise. Thank you very much!!

8 Replies
MVP
MVP

Re: Reformating Data Assistance

Hi

This expression should do the trick:

=Concat([Company Names], ',')

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Reformating Data Assistance

Use Concat(Company Names).

Not applicable

Re: Reformating Data Assistance

Hello Jon,

Thank you for your suggestion.

I tried but keep getting error. Please see below is the codes I am trying to reformat the data. MOC_Entity is the field I would like to add a ‘,’. Can you advise where to add in the codes please?

MOC_Entity:

Load MOC_OrderID,

MOC_OrgCoy as MOC_Entity

resident MOC_Headline;

Load MOC_OrderID,

MOC_TakeCoy as MOC_Entity

resident MOC_Headline;

Thanks!

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Not applicable

Re: Reformating Data Assistance

Hello Kumar

Thank you for your suggestion.

I tried but keep getting error. Please see below is the codes I am trying to reformat the data. MOC_Entity is the field I would like to add a ‘,’. Can you advise where to add in the codes please?

MOC_Entity:

Load MOC_OrderID,

MOC_OrgCoy as MOC_Entity

resident MOC_Headline;

Load MOC_OrderID,

MOC_TakeCoy as MOC_Entity

resident MOC_Headline;

Thanks very much!

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Not applicable

Re: Reformating Data Assistance

Hi Jon,

Please see attached file, which will explain what is the result I am trying to get..Thanks!

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Not applicable

Re: Reformating Data Assistance

Attached shows the result I am trying to get…any suggestions please?

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Not applicable

Re: Reformating Data Assistance

I am getting error. Please see email I send to you for explanantion.

Not applicable

Re: Reformating Data Assistance

Please assist. I am getting errors

Community Browser