repeat specific cell after the detail data

[Mic]

Hi everyone,

Is it possible to arrange the designation under the “Spezifikation” next to the “Messeinheit”?

(I thought it works with the Generate Rows Tool and Record ID Tool, but unfortunately I can't get it)

I would be very grateful for suggestions for solutions.

Input data:

  

Output should look like this:

[binuacs]

@Mic Can you upload the input file?

[JamesCharnley]

@Mic as Binuacs said it's a bit easier if you can upload some kind of input, even a mocked up one to save someone from having to retype it out in order to provide a practical solution. In the absence I'll try to explain an option of what you could do though.

Since you're essentially looking to create a new column based on something in column one, the first thing you'd want to do is tag these different 'Spezification' into groups with something like a tile or multi-row formula tool. Then you'll want to isolate those Mengeneinheit rows with a filter, and at that point you'd be able to join them back on with a join tool based on the tag you just made. You'd then need a bit more to reformat it but that's the general idea.

[Mic]

I hope the excel file will help you. I haven't created a workflow yet. 

[JamesCharnley]

@Mic  Something like this is doing what I tried to explain:

[ShankerV]

Hi @Mic 

Please find the expected solution in 2 tools.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Mic 

Step 1: Input

Step 2: Filter

Step 3: 

if [Field4]="Messeinheit" and Isnull([Row-3:Field4])
then [Row-2:Field1]
elseif [Field4]="mm" and [Row-1:Field4]="Messeinheit"
then [Row-2:Field1]
elseif [Field4]="mm"
then [Row-1:New Field]
else ""
endif

Expected output:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

[Mic]

Thanks @ShankerV, this works great!

[ShankerV]

Hi @Mic 

Glad to know it worked for you!!! Thanks!!!