Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Updates & Insights
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
      • About the DevOps Program
      • DataMiner DevOps Support
  • Downloads
  • More
    • DataMiner Releases & Updates
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

use like in gqi join condition

Solved532 views19th November 2024GQI Filter GQI queries
1
joel_ joly378 18th November 2024 0 Comments

Hello DOJO

Is it possible with gqi to join 2 tables by using a like clause ?

for example:
if the column in A is ‘448959-33445-35’. Then the join would match if column in B is either: ‘448959-33445-35.10/2024’, ‘448959-33445-35.11/2024’, or just ‘448959-33445-35’

I know it’s possible with SQL like this :

SELECT *
FROM TABLE a
JOIN TABLE b ON b.column LIKE 'a.column +'%'

It would be very helpfull to know how to achieve this 🙂

joel_ joly Selected answer as best 19th November 2024

3 Answers

  • Active
  • Voted
  • Newest
  • Oldest
2
Tobe Deprez [SLC] [DevOps Advocate]894 Posted 19th November 2024 0 Comments

I do not think a join with a like clause is possible in GQI. However, depending on the exact format of the column in A, you might be able to do a regex column manipulation on ‘b.column’ to extract the relevant information (like ‘448959-33445-35’) into a new column (demonstrated below with another column)

and then join a and b on a.column and b.new_column.

joel_ joly Selected answer as best 19th November 2024
2
Ward Haeck [SLC] [DevOps Enabler]3.52K Posted 19th November 2024 0 Comments

Hi Joel,

You could achieve this by first using a Regex column manipulation and than join on the newly created column:

Hope this helps!

Best regards, Ward

Ward Haeck [SLC] [DevOps Enabler] Answered question 19th November 2024
0
joel_ joly378 Posted 19th November 2024 0 Comments

Thanks to both of you.
This solution suits me very well for this specific case.

I think it will be part of many future usage. 🙂

joel_ joly Answered question 19th November 2024
Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs