Can i remove the relationship between two tables?

[#1]

Hi Guys,

I have different tables and i don't want all of them to link. Is their any possibility of doing so.....

Plz help in the same

Thanks in Advance

Sagar Gupta

[#2]

Hi Srmsagargupta,

You are finding a link between different tables, because I am assuming these tables share the same field name.

To remove the link, rename the fields in your table so that they are unique - within the load script, using the "as" command (see below for example)...

in the load script

Table1:

Load

Data,

Value

from XXXX

Table2:

Load

Data as Data2,         <-----------

Value as Value2       <-----------

from XXX

Hope this helps?

Kind regards,

Rich

[its_anandrjs]

Hi,

For separate two tables you can use Qualify command before the load of the table like

Qualify *;

Load

*

from source;

Regards,

Anand