Forum Discussion

DRJ1994's avatar
DRJ1994
Helper I
3 years ago

Help with Delimiting

Hi guys,

 

Hopefully someone can help with my query, although I am not sure if what I am trying to do is possible or not.

 

I have a table with the column pictured below. 

I am trying to delimit by ";" (The / is fine and I do not need to delimit by this). So if we take the top row for example it should be split into rows as follows:

Attendance allowance / state pension / pension credit
Benefits advice

Physical health

Visit

Well being

 

The issue I am having is PBI is counting these now as 5 seperate entries rather than 1. For example the source data there are only 4600 entries, but when I delimit in PBI and performing a count there are over 12000 entries. So I think the issue is that it is counting each row as it's own entry, I understand why this is happening but I am just trying to see if there is a way to bring it closer to the 4600 that is on the source data.

 

Is there a way to fix this? I have tried a few different things but have had no joy. 

 

Thanks in advance.

 

DRJ.

1 Reply

  • HotChilli's avatar
    HotChilli
    Community Champion

    What are you trying to fix? 

    --

    Are you trying to find a way to keep the related rows 'together'?  If so, are there any other columns in the table which act as a key?