Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Concatenate the table name to the field using string concatenation, e.g.
Load 'tab1.' & id as id
inline[
id
1
];