LakshSudha
Last Activity: Apr 11 '14, 12:14 PM
Joined: Apr 9 '14
Location:
-
I have worked on this one and got the output now.. Thanks a lot for your help :) -
Hi.. Actually the concept is to concatenate the abbreviated_ name with comma separator.If the project id does not have any abbreviated_nam e then it should take its secondary_appli cation name.
Example : 1. project_id 1000 has only two abbreviated_nam e and it does not have the abbreviated name for ACA. So in the output it has taken the secondary_appli cation name which does not have the abbreviated name. finally the output for project_id 1000...Last edited by zmbd; Apr 10 '14, 11:37 AM. Reason: [Z{Please use the [CODE/] button to format posted script and formated text - Please read the FAQ}]Leave a comment:
-
How to concatenate two columns using vba code
The output sholud display the abbreviated name with comma separator. If the project does not have abbreviated name means it should take its secondary_Appli cation name. I need the VB macro for the output table.
I have a source table like below
...Code:PROJECT_ID SECONDARY_APPLICATION ABBREVIATED_NAME 1000 3D Static SDSSPP 1000 ACA 1000 Multi Rater
Last edited by zmbd; Apr 9 '14, 12:38 PM. Reason: [z{placed code tags to preserve formatted table replacing tabs with spaces}]
No activity results to display
Leave a comment: