Find the Id_predepositado in the dep_predepositos table, from the dep_envio table

[Pablo_Barria_Ge]

Good guys,

In the Id_predepositado  field of the dep_envio table,

Find the Id_predepositado in the dep_predepositos table, from the dep_envio table

But the result is in an enumlist field brings me the field completely and I just want the ID.

Hugs,
Pablo

[dbaum · Accepted solution]

The issue may be that your CONTAINS expression references the entire column of values rather than only the current row's values in the indicated column. Consider:

SELECT(dep_predepositos[Id_predepositado], CONTAINS([id_envioP],[_THISROW].[id]))

[dbaum]

Maybe try using IN instead of CONTAINS in your expression. Does that achieve what you expect?

[Pablo_Barria_Ge]

same result, samples 2 Id_predepositado

Thank you

[dbaum · Accepted solution]

The issue may be that your CONTAINS expression references the entire column of values rather than only the current row's values in the indicated column. Consider:

SELECT(dep_predepositos[Id_predepositado], CONTAINS([id_envioP],[_THISROW].[id]))

[Pablo_Barria_Ge · Accepted solution]

It works perfect

SELECT(dep_predepositos[Id_predeposito], CONTAINS([id_envioP],[_THISROW].[id]))

because adding the name of the table causes that error dep_predepositos[Id_envioP]

muchas gracias, por tu enorme ayuda.

thank you very much for your great help

Pablo

[dbaum]

De nada.