Sort and match variables from lookup tables to create concatenated string

[jaryszek]

Hi Guys,

i have list in column A like here:

Screenshot_43.png

where i have to loop one by one and match with SourceTables(T_region,t_Device,t_Genre,t_Order) order and values.

The Result is:

Urządzenie > PC, Gatunek > Akcja, Adveture, Region > Wersja Global
(Device> PC, Genre> Action, Adventure, Region
> Global)

So first of all i have to match all variables from column A and know from what table is coming from (like using if statement from source tables):

GLOBAL--> Wersja GLOBAL (t_Region)
PC --> PC (t_Device)
Adventure --> Przygoda (t_Genre)
Action --> Action (t_Genre)

And after this i want to create concatenated string based on Category (table entity) and atributes (example without ORDER):

[A2]: Region > GLOBAL (i know that global is in t_Region table)
[A3]: Device > PC (i know that PC is in t_Device)
[A4]: Genre > Adventure (i know that Adventure is in t_Genre table)
[A5]: Genre > Action (i know that Actionis in t_Genre table)

result:
Region > GLOBAL, Device > PC, Genre > Action, Adventure

As you can see Region is Parent Category and Global is the atribute of it so i have Region > GLOBAL,
in case of Genre we have 2 atributes so i have Genre (Parent) > Action, Adventure.

And what is important i have to maintain also order from t_Order table:
Name Order
Device 1
Genre 2
Region 3

So we have as last result:

Device> PC, Genre> Action, Adventure, Region > Global which translates (match from source tables) into: Urządzenie > PC, Gatunek > Akcja, Adveture, Region > Wersja Global

Do you have maybe any idea for this?
What objects i can use and how to do this?

Please help,
Jacek

[jindon]

Not really sure about the logic of your result, so outputs differently.

Please Login or Register  to view this content.

[jaryszek]

thank you jindon very much!

It is awesome!

I think i have to change a little but i can adjust it.

Best,
Jacek