Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel sheet as query input

Hello,

I have a question on the usage of excel sheets as query input.

Suppose I have a database containing persons (defined by an ID, column 1). For every person a birthday is associated (column 2).

Can I use an excel sheet as input for querying the database, returning me the birthdates of the persons listed in the excel sheet? The persons in the excel sheet are a subset of all possible persons.
I can not get it done...

The goal is to implement an automated query mechanism that yields results for the entries of the excel sheet.

Thanks in advance,
Sasha

1 Reply
Not applicable
Author

Hello , You can read the Excel sheets names and birthdates into first table and then you can fetch the values from the database into the second table using the first tables anmes or Birthdates.