Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Creating Report

I have a report that I transform Data by splitting the column.   1. Split a column by Delimiter     a. Split column into 5 columns 2. Select or enter Dilimiter     b. by Custom          ;# 3. E...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous 

It is not clear what do you mean by append!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    There are 5 columns that are labeled issue /key words 1 - 5. Issue / key words 2 - 5 are appended to Issue / key words 1. 
    The fields that would be used to join the issue /key words are MCP, Tracking  #, Provider Type, Responsible Tracker and Date sent to MCO.  All Issue / Keys words are in one field until I separated them. I need to count each Issue / Key words individually.    

    e.g., MCP, Tracking #, Issue/ Key Words, Provider Type, Responsible Tracker, Date Sent to MCO