Forum Discussion

Fra4's avatar
Fra4
Regular Visitor
3 years ago

Filter table with values from another table

Hello everyone, I have a table with the following columns I would like to filter this table with another table as the following using the column "Articolo" So basically I would like to...
Need Help
Tips and Tricks
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Hello.

I have this very question:

I have two related tables, one is called Pc (2) and the other Tasks (2), in the Pc table I have these fields: id_host_name (type ABC), user_name, First_name, model, Tags, Serial, Type, and in the Tasks table (2), you have these fields: id_host_name, of type ABC, date, hora_inicio, and hora_fin, of type date, usuario_wso, wifi, autologin, teamviewer, tag, dell command, bios_update, login_mdm, windows_update, reviewed, registered, are of type Yes/No.

I need to filter the quantity or name of the ordnenadores that are not yet loaded in the Tasks table (2), but if they appear in mim fact table Pc (2), know quantity and a list of the resulting id_host_name field.

Thanks a lot.