How to extract data from two different logical tables in a single load (In script level)

[#1]

Please help me out to extract data from two or more logical tables in single load..

i have a big dought like why can't we use resident with sources supprated with any delimiter

like

load ...

resident a,b,c; ???

Please help me out..

Thankyou in advance 🙂

[Anonymous]

Each resident load can just pull data from one target table.

If you're trying to pull fields with the same names from the different tables you can use a for loop:

for each Test in 'A', 'B', 'C'
load
FieldX

resident '$(Test)';
next

[#3]

thankyou Johannes Sundén ,but in case of different fields what would be the better solution..please let me know if you have any solution for this 🙂

[Anonymous]

First I would ask myself why I need them in one table. I'm sure there might be good reasons for it though but you would have to set up different load statements for the different tables and then join them over keyfields to create your joined table. You can't query several tables in one load statement.