Is an iterative Macro needed?

Hello together,

I am still a beginner in Alteryx and I would appreciate your help:

In the file below I have written the Child ID... and I want a workflow that gets me the respectiv Parent ID, which is mostly build as the Child ID but without the last segment (see attached file). How can I do that dynamically? Do you have a good idea for that?

Mappe1.xlsx

Iterative Macro

Accepted answers

Qiu

@RAM-ler
If you want to generate a Parent-child hierarchy we can use this macro.

https://community.alteryx.com/t5/Community-Gallery/Hierarchy-Generation-Macro/ta-p/880709

0721-RAM-ler.yxzp

All comments

Qiu

@RAM-ler
If you want to generate a Parent-child hierarchy we can use this macro.

https://community.alteryx.com/t5/Community-Gallery/Hierarchy-Generation-Macro/ta-p/880709

0721-RAM-ler.yxzp

KGT

Are you just trying to knock the last segment off?

Trimright([ChildID],".") and then find the last Full Stop and trim that with Left([ChildID],Length([ChildID])-Findstring(ReverseString([ChildID]),"."))

RAM-ler

@Qiu Thats wonderfull, that really worked out!!! Thanks a lot!
Best regards,

Baraa

RAM-ler

@KGT yes exactly, thats what I am trying to do... and I tried that your suggestion a lot but it did not work

Solution2.png

KGT

In that screenshot, the second formula needs to act on the result of the first formula. I probably didn't show that well in text.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703