using table name as field value

[Mapuna]

I want to use the table name as field values. Can i use Qualify for this?

eg:

qualify *;

tab1:

load * inline[

id

1

];

concatenate

tab2:

load * inline[

id

2

3

];

now tab1.id and tab2.id fields will be created after conacatination. how can i use this and make the tab1 appear infront of id 1 and tab2 against id 2 and 3.

Basically can i use the field name and spilt the name?

[Or]

Concatenate the table name to the field using string concatenation, e.g.

Load 'tab1.' & id as id

inline[

id

1

];