topic Re: Reg: Loading with one table in 2 datasets in QlikView

Reg: Loading with one table in 2 datasets

lakshmanvepuri — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Reg: Loading with one table in 2 datasets

Digvijay_Singh — Fri, 11 Mar 2016 13:27:12 GMT

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

Re: Reg: Loading with one table in 2 datasets

t_chetirbok — Fri, 11 Mar 2016 13:30:49 GMT

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;

Re: Reg: Loading with one table in 2 datasets

O11235 — Fri, 11 Mar 2016 13:44:58 GMT

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;

Re: Reg: Loading with one table in 2 datasets

maxgro — Fri, 11 Mar 2016 21:18:58 GMT

noconcatenate

but why you want 2 tables with the same data?