Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jonathandienst
Partner - Champion III
Partner - Champion III

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
Author

Use Concat(Company Names).

Not applicable
Author

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
Author

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
Author

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
Author

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
Author

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

Not applicable
Author

Please assist. I am getting errors