Skip to main content

Dear FME community.

I would like to make a loop with concatenation of values like a hierarchy.

The result like that :

In this case I can have 1, 2, 3, ... x levels, that's why I don't know how to do that.

Thank you for your help.

Hi @lalandexavier, it's an interesting challenge. This is my first inspiration.

# Possibly the RESULT for ID = 6 should be "B/F"?


You could use the VariableSetter and VariableRetriever for this, see attached template (FME 2018.1).

Result:

build-hierarchy.fmwt


Hi @lalandexavier, it's an interesting challenge. This is my first inspiration.

# Possibly the RESULT for ID = 6 should be "B/F"?

Almost exactly the same 🙂

You could use the VariableSetter and VariableRetriever for this, see attached template (FME 2018.1).

Result:

build-hierarchy.fmwt

Thank you very much @david_r that's perfect !

Hi @lalandexavier, it's an interesting challenge. This is my first inspiration.

# Possibly the RESULT for ID = 6 should be "B/F"?

Thank you very much @takashi Your answer complete the answer of @david_r

Reply