I’m trying to solve an issue that for sure will be easy for you to solve, but I don’t know how to proceed.
I need to make an ARRAY between two tabs that meets the conditions between two values of a column.
OK, reading that burned my eyes a little. Do you have any screenshots of real data, so it’s a little easier to understand? What I’m thinking you may need is a Make Array column to join multiple values and arrays together.
I will expose the real case and it will be easier. I’m making a real estate portal, where an admin publishes demands and other employees publish properties and I’m stuck in crossing properties and demands.
“Properties” have some attributes such as Price, location, type of property (residential, office…) and typology ( Plot, building…), and I want to match it with the “Demands” Range of price, range of location, range of types, and range of typology. The result has to be a list per Property of Demands where this property fits.
My initial thinking to solve it was to make an array comparing each parameter and after that to join it in another array to compare it. If you need I can show you the table, but for sure I don’t have it in a proper way.
At the picture above “rel_Demandas 1” relates Properties “Tipo” and Demand “Tipo”, and “rel_Demandas 2” relates Properties “Tipología” and Demand “Tipología”, and I need a column that has the items that are only in either the two colums, removing the items that are only in one of both.