Wrong answer for crossing fields selection

[gilson_carciofi]

Hello Experts !

I am struggling with an issue regarding the result of crossing the selection of two fields. I have created my data model like that:

What I have to do is: When I select "Voluntario" value in "Natureza_Deslig" field in certain date, "Descrição Movimentação" field must show "PROMOCAO" equal 2, as in the example bellow (figure A). Instead no value is retrieved for "Descrição Movimentação" as figure B shows.

Figure AFigure B

What I have to do for correct that relantion ?

Thanks a lot.

Best Regards.

@hic 

@Clever_Anjos 

[Lisa_P]

What is the contents of your Chave.. Field ?  This is obviously the key

[gilson_carciofi]

Hi Lisa !

Yes it is.

Matricula & '|' & Data AS [Chave Matricula e Data]

2000529|01/08/2019

2000529|01/10/2019

etc..

Thanks for your support.

[Lisa_P]

I don't fully understand the relationships in your data, but check the values of your keys in all tables if you are not getting the relationships you expect.

[Gui_Approbato]

What if you link "Demissões" and "Salarial" directly?

Try changing your key between them, like:

In Demissões, change the name  [Chave Matricula e Data] to [Chave 2] 

In Salarial, duplicate the column but change the name of one of them to [Chave 2] too

See if they interact the way you expect.

Best

[gilson_carciofi]

I will see.

Thank you all.

[balabhaskarqlik]

Try to debug the script, how data is loading. First try to load limited tables, filter the data b/w different fields, gradually add other tables too. Again filter the data & check how the association happened b/w tables. Break the script, then easily you could find out the actual issue.

[Clever_Anjos]

Please dump your "Chaves d..." table and attach it here, let me check.

I'm guessing you're having different date formats