Reg: Loading with one table in 2 datasets

[lakshmanvepuri]

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

[Digvijay_Singh]

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

[t_chetirbok]

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;

[O11235]

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;

[maxgro]

noconcatenate

but why you want 2 tables with the same data?