Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

joining tables 2 SQL 1 excel

I need help in joining tables 2 SQL and 1 Excel file

Three tables with PhrNPI and DateRange   combined hrxs and orderentry

Two tables with RxNo   hrsx and orderentry

is this possible?

22 Replies
Not applicable
Author

This is what I have now

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

You have to drop the PhrNPI too.. add this along with RxNo drop statement.

Drop  Field PhrNPI from  OrderEntry;

Not applicable
Author

No Errors YES

but now the sheet does not work

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Do me a favor. Can you send me your QVF file to me. I will see what else is missing,

Not applicable
Author

How do I attach it

Not applicable
Author

The file is 57344KB

Not applicable
Author

ok I changed the date span to include less data

But don't see were to attach it at? !

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

On reply screen you will see "Advanced Editor" on top right corner. click on that and you will attach option at bottom.

Not applicable
Author

Don't see it