Discussion Board for collaboration on QlikView Scripting.
I would like to know how to format the data below.
ToABC, DEF, PQR, XYZ
Please kind advise. Thank you very much!!
This expression should do the trick:
=Concat([Company Names], ',')
Hope that helps
Use Concat(Company Names).
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_OrgCoy as MOC_Entity
MOC_TakeCoy as MOC_Entity
Product Manager for eWindow®, Global Trading Services
12 Marina Boulevard
#23-01, Marina Bay Financial Centre Tower 3
DID (65) 6530 6415 | Support (65) 6530 6530
Mobile (65) 9108 4192 | F (65) 6532 2700
Yahoo : firstname.lastname@example.org<mailto:email@example.com>
Thanks very much!
Please see attached file, which will explain what is the result I am trying to get..Thanks!
Attached shows the result I am trying to get…any suggestions please?
I am getting error. Please see email I send to you for explanantion.
Please assist. I am getting errors