Hi Freddie,

You could use an InlineQuerier to solve this. I have made a begin with the query to use. This query looks up labels for data.100003 and data.100004. Just add all the other columns the same way. The query to use is:

select "MeldingData"."id"

, "MeldingData"."latitude"

, "MeldingData"."longitude"

, "MeldingData"."pin_icon"

, "MeldingData"."locally_created"

, "MeldingData"."data.100003"

, "fd100003"."label" as "label.100003"

, "MeldingData"."data.100004"

, "fd100004"."label" as "label.100004"

from "MeldingData"

, "FormData" fd100003

, "FormData" fd100004

where "fd100003"."id" = 100003

and "MeldingData"."data.100003" = "fd100003"."value"

and "fd100004"."id" = 100004

and "MeldingData"."data.100004" = "fd100004"."value"

The workspace itself will be pretty easy:

Greetings

Arno

@freddie_kwak

Featuremerger solution. more generic(ish) and less typing ;)

Dynamci key Kwak.fmw

@freddie_kwak

Updated, added the not merged objects (in case you did not figure it out yourself, which is presumed)

31082-dynamci-key-kwak.fmw

Ouptutexample added.

Question;

Are integer values in the data. columns which are seperated by comma' s multiple values ?

Hello Gio, sorry for my late reaction! The data. columns do not have multiple values. Always a single value. Thank you for your help! It works realy well! learned a new FME-skill! Thank you for that!

Hello Arno, thank you for the solution! Also works very well! Sometimes difficult to understand for me, but good to know i can solve these kind of problems with the InlineQuerier! Thank you for your help!