Hello, I have a data set where the number of fields will shift dynamically. I need to place an empty column in front of columns that contain one of two prefixes. Example: NameIDABC_923ABC_928TotalXYZ_876XYZ_572 Would be transformed into this: NameIDABC_923_2ABC_923ABC_928_2ABC_928TotalXYZ_876_2XYZ_876XYZ_572_2XYZ_572 Any help would be hugely appreciated. Thanks!

Create new columns in front of columns with certain prefix

Hello,

I have a data set where the number of fields will shift dynamically. I need to place an empty column in front of columns that contain one of two prefixes.

Example:

Name	ID	ABC_923	ABC_928	Total	XYZ_876	XYZ_572

Would be transformed into this:

Name

ABC_923_2

ABC_923

ABC_928_2

ABC_928

Total

XYZ_876_2

XYZ_876

XYZ_572_2

XYZ_572

Any help would be hugely appreciated. Thanks!

Help

Accepted answers

Greg_Murray

@Mtvbqb

This was a little tricky. I am sure there are better solutions out there, but this worked for me.

see attached.

-Greg

new col example.yxmd

All comments

AbhilashR

@Mtvbqb - does the attached solution work as an acceptable solution in your case?

sample.yxmd

Greg_Murray

@Mtvbqb

This was a little tricky. I am sure there are better solutions out there, but this worked for me.

see attached.

-Greg

new col example.yxmd

AbhilashR

@Greg_Murray - I love the way you managed to programatically get your column order intact. Definitely using this approach in my day-to-day work!

Mtvbqb

Thanks for the solution! This is exactly what I struggled all morning to achieve!

Keeping the column order was vital, so thanks again for that!

grossal

I know I am a bit late, but I want to post my result anyway 😉

I came up with a similar approach to @Greg_Murray but was able to save some tools.

Workflow is attached.

Alex

2020-03-27-insert-columns-with-condition.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703