Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Shashank1987
Contributor
Contributor

Multiple Data Loads

Hi,

I am trying to convert a SQL procedure to Qlikview script.

DataTable:

Policy Number Policy Name Flag

1| ABC| Flag1

2| ABC| Flag1

3| ABC| Flag2

4| ABC| Flag3

SQL Script:

Insert  into Policytable

Select * from DataTable ;

Insert  into Policytable

Select * from DataTable 

where Flag <> "Flag1"

Insert  into Policytable

Select * from DataTable 

where Flag  not in ("Flag1","Flag2")

Can this be replicated in Qlikview?

 

 

 

Labels (2)
1 Reply
mayuringale25
Partner - Creator
Partner - Creator

Hi @Shashank1987 

Check the attached qvf. 

Hope you want this model

Thanks and Regards
Mayur Ingale