topic Re: New column creation based on the letter "P" in Alteryx Designer Desktop Discussions

New column creation based on the letter "P"

deepnandi — Thu, 03 Oct 2024 05:46:30 GMT

Hi All,

I am unable to create a new column where the cells are repeated depending on the first letter "P" present in metric column. Below screenshot explain the input column and how the new column output should be.

Any help will be highly appreciated.

Re: New column creation based on the letter "P"

ShankerV — Thu, 03 Oct 2024 06:03:15 GMT

Hi @deepnandi

Hope the below method helps!!!

Many thanks

Shanker V

Re: New column creation based on the letter "P"

OTrieger — Thu, 03 Oct 2024 07:38:09 GMT

@deepnandi
The above solution by @ShankerV is simple and workable, just do not forget to add a Select tool after the Filter tool to remove any unneeded fields before Appending it and you can rename it too.

Re: New column creation based on the letter "P"

deepnandi — Tue, 08 Oct 2024 04:57:32 GMT

Thanks @ShankerV it worked.