topic Re: Use number of indents to produce a numeric outline to produce a unique id in Alteryx Designer Desktop Discussions

Use number of indents to produce a numeric outline to produce a unique id

hellyars — Mon, 24 Aug 2020 18:50:53 GMT

Hi,

This is pretty messy. I have a Build Of Materials (BOM). Part Numbers are not unique IDs. Parts, such as a bolt, may be used multiple times across the BOM. I want to compare different iterations of the BOM, so Record ID will not work across iterations. The BOM is indented. The indentation references + the part number are still not unique. They could be, if I could convert the Indent reference to a number outline.

Here is an example of what I want to do. In reality, there are 82,000 lines and up to 12 indent references.

How can I construct a formula to create this translation?

Indent Reference	Desired Outline ID
1	1
1,1	1.1
1,1,1	1.1.1
1,1,1	1.1.2
1,1,1,1	1.1.2.1
1,1	1.2
1,1,1	1.2.1
1,1,1	1.2.2
1	2
1,1	2.1
1,1,1	2.1.1
1,1,1,1	2.1.1.1
1,1,1,1	2.1.1.2
1,1,1,1,1	2.1.1.2.1
1,1,1,1,1,1	2.1.1.2.2.1
1,1,1,1,1,1	2.1.1.2.2.2

Re: Use number of indents to produce a numeric outline to produce a unique id

Greg_Murray — Mon, 24 Aug 2020 21:18:35 GMT

@hellyars

this works for the example you have below with the exception of the last couple rows. You may have to tweak the iterative macro to work with your actual data.

Re: Use number of indents to produce a numeric outline to produce a unique id

hellyars — Thu, 27 Aug 2020 20:44:55 GMT

@Greg_Murray First, thank you. Two, sorry for not responding earlier. Three, this works perfectly. My example is what is off. The last two rows in my desired outline example are incorrect. Awesome! Now, I have to study this macro.

Re: Use number of indents to produce a numeric outline to produce a unique id

hellyars — Fri, 28 Aug 2020 17:48:55 GMT

@Greg_Murray HELP. It only works within your file. It stops working if I try to bring the macro into another workflow (to include a new workflow). The only way I can get it to work is to import my workflow into yours. What am I doing wrong?

Re: Use number of indents to produce a numeric outline to produce a unique id

Greg_Murray — Fri, 28 Aug 2020 17:54:13 GMT

@hellyars can you screenshot what you are seeing and/or share a sample of the workflow you are trying to use it in?

Re: Use number of indents to produce a numeric outline to produce a unique id

hellyars — Fri, 28 Aug 2020 18:01:44 GMT

@Greg_Murray Thanks for the quick response. I will have to wait for it to happen again. I deleted the corrupt version and restarted with a clean copy of your example. So far, it is working. But, this has happened several times. Next time I will document it.