Split to rows before transpose-causing dups within cell

[Hi2023]

I am trying to make sure my columns are not dup within each cell. How do I correct?

[binuacs]

@Hi2023 have you tried with the unique tool

[Hi2023]

No, that didnt work, I want each line to show for each acct# listed for that control#

[JamesCharnley]

Hi @Hi2023,

This is going to be a bit of guess work without the rest of the workflow, but normally when you're getting duplication within a cell like that, you're aggregating somewhere, I'd expect in a cross-tab, without grouping by some kind of row level identifier. I'd expect you'll need to use a record ID tool, multi-row tool or a tile tool before the cross-tab (depending on your data, i'm not sure which will be most appropriate) and then group by that. Since it looks like you want multiple rows per Control Number, this should stop the data aggregating to the single Control Number level.

[Felipe_Ribeir0]

Hi @Hi2023 

Try to select the Account Number on the key columns of your transpose tool

[Hi2023]

after Reglex

[Felipe_Ribeir0]

Hi @Hi2023 

Please see if the attached workflow works for you. After testing it, replace the text input for the regex output part

[Hi2023]

thanks I will try now!