Noconcatenate on two similar tables and two different sheets

[#1]

Hi,

I have two tables like below

Table A:

NAME     DOB     EmpID     Company     Salary

Table B:

NAME     DOB     EmpID     DeptID     Supervisor

And I don't want to associate both the tables by Join or concatenate.

I have two different sheets in my dashboard.

Sheet A deals with Table A, not with Table B data and

Sheet B deals with Table B, not with Table A data...

Is there a way i can implement this scenario into my QVW file? Basically I don't want Table B data flows into Sheet A.

I don't want to use Qualify *; to restrict the default concatenate.

Thanks,

Suresh

[trdandamudi]

Did you tried NoConcatenate  ?

Example:

Load A,B from sample_file1.csv;

noconcatenate load A,B from sample_file2.csv;

[MK_QSL]

Add Flag in both Tables

'TableA' as Flag

'TableB' as Flag

Now you can use both Table data differently using this flag

[maxgro]

it's not clear why you don't want to associate or concatenate

anyway if you want not associated tables, change the fields names

Table A:

load

NAME as NAMEA,    DOB as DOBA,     EmpID as EmpIDA ,    Company,     Salary

from ....;

Table B:

load

NAME,     DOB,     EmpID,     DeptID,     Supervisor

from .....;