Qlik Community

Qlik Catalog Discussions

Discussion Board for collaboration on Qlik Catalog

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

How to ingest filtered datasets?

Is it possible to create new entities in the Source module by loading filtered data from RDBMS through custom sql queries?

Labels (1)
2 Solutions

Accepted Solutions
Highlighted
Employee
Employee

Re: How to ingest filtered datasets?

@ssamuels , 

Yes, in the QDC Help, search for  'src.file.glob' in Qlik Data Catalyst Source Properties, and you will find what you need. Against RDBMS sources, that property drives the query that's executed to pull the data for that entity. When we build it anew, it's simply a list of the columns in the table, but it can be edited. Want to query a view? Add a sub-select, or a join? All are allowed. 

Hope that helps, 

David

 

View solution in original post

Highlighted
Employee
Employee

Re: How to ingest filtered datasets?

@ssamuels 

100% correct. That's how you can build an entity in QDC that will reflect any values you would like. Subqueries, LOJ's, Views, partitions, etc ... all are supported. If it's SQL-92, it should work. 

thanks, David

 

View solution in original post

5 Replies
Highlighted
Employee
Employee

Re: How to ingest filtered datasets?

@ssamuels , 

Yes, in the QDC Help, search for  'src.file.glob' in Qlik Data Catalyst Source Properties, and you will find what you need. Against RDBMS sources, that property drives the query that's executed to pull the data for that entity. When we build it anew, it's simply a list of the columns in the table, but it can be edited. Want to query a view? Add a sub-select, or a join? All are allowed. 

Hope that helps, 

David

 

View solution in original post

Highlighted
Employee
Employee

Re: How to ingest filtered datasets?

@ssamuels  , 

Can I ask I this solution is the one you were looking for? If so, would you mind closing the case? Otherwise, any other questions are welcome. 

 

Thanks, David

 

Highlighted
Partner
Partner

Re: How to ingest filtered datasets?

Thanks @DaveHowland  for your answer.

Highlighted
Partner
Partner

Re: How to ingest filtered datasets?

@DaveHowland Does this mean that I can use this property to specify my own custom sql queries to pull the data from the database?

 

Highlighted
Employee
Employee

Re: How to ingest filtered datasets?

@ssamuels 

100% correct. That's how you can build an entity in QDC that will reflect any values you would like. Subqueries, LOJ's, Views, partitions, etc ... all are supported. If it's SQL-92, it should work. 

thanks, David

 

View solution in original post