Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Reg: Loading with one table in 2 datasets

Hi ,

I am having scenario like this.

STATUS1:

SELECT      

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

STATUS2:

SELECT      

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

After running the script I am getting only STATUS1

Please let me know how to achieve STATUS1 and STATUS2  after reloading without any issue.

Thanks a lot

Lakshmana

4 Replies
Highlighted
Master III
Master III

Re: Reg: Loading with one table in 2 datasets

All fields are same so both tables get concatenated. If you want different tables then use NOCONCATENATE in between.

Specialist
Specialist

Re: Reg: Loading with one table in 2 datasets

Hello! you should use noconcatenate or qualify or rename your fields in second table

try this

QUALIFY *;

STATUS1:

SELECT      

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

STATUS2:

SELECT      

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

Highlighted
Contributor III
Contributor III

Re: Reg: Loading with one table in 2 datasets

Agreed

you can use Qualify *;...Unqualified.

NoConcatinate I find is more useful.

eg.

[STATUS1]:

NoConcatenate

SELECT     

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

[STATUS2]:

NoConcatenate

SELECT     

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

Highlighted
MVP
MVP

Re: Reg: Loading with one table in 2 datasets

noconcatenate

but why you want 2 tables with the same data?