User Profile
JoaoLourenco
New Member
Joined 1 year ago
User Widgets
Contributions
Re: Find text in different columns and different tables
Hi rajendraongole1 , Thank you for your reply. Sure yes! Let's see. I want to check if the [ID Matr] of Table 1 exists in the [Designation] of Table 2. If true, return "YES" If false, retun "No" (for example, or maybe can count how many times found that). Table 1 ID_Matr 60-95-IG 72-TG-18 59-VM-35 AE-59-UJ 91-69-XU 91-71-XU 10-CA-75 54-HB-73 96-SS-96 Table 2 Cód Designation 2375 IM001880 TD 91-69-XU Veículos Automóveis Ligeiros & Mistos 2375 IM001881 TD91-69-XU Veículos Automóveis Ligeiros & Mistos 2375 IM001884 TD 91-71-XU Veículos Automóveis Ligeiros & Mistos 2040 IM000678 Furo Covelo Trabalhos Hidráulicos Incl. Poços ÁguaTM 2385 IM001888 Nissan 10-CA-75 Veículos Automóveis Pesados com Atrelado 2375 IM001886 Nissan 54-HB-73 Veículos Automóveis Ligeiros & Mistos 2040 IM000680 Furos - Abertura Trabalhos Hidráulicos Incl. Poços ÁguaTM 2385 IM001892 Isuzu 72-TG-18 Veículos Automóveis Pesados com Atrelado 2040 IM000681 Furos Sisa Trabalhos Hidráulicos Incl. Poços ÁguaTM Thank you!667Views0likes0CommentsFind text in different columns and different tables
Good afternoon, I would like help with the following: 1.I want to know if the data from the [Registration] field in the 'Vehicles' table is found in the [Asset Elements Description] field in the 'Model 32' table If true, then write for example "YES" If false, then write for example "NO". I've tried several functions from Search, FIND, CONTAINS and I couldn't. I apreciate your help. Thank you!Solved695Views0likes4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.