Join all the fields of two tables

[#1]

Hi,

I simply would like to join two tables, withtout specifying the fields, example:

Join:

LOAD * Resident Values;

Inner Join LOAD * Resident Formula;

If i do that it doesn't work. I have to specify the fields to load after the load statement...is there a solution to join all the fields?

Thank you.

[Jason_Michaelides]

What do you want the resulting table to look like?

[#3]

would like that:

[Jason_Michaelides]

Join:

NoConcatenate

LOAD

*

Resident Values;

LEFT Join (Join)

LOAD

*

Resident Formula;

...should do it.

[somenathroy · Accepted solution]

You can try with this below code:

Formula:
LOAD * Inline [
KEY, FORMULA
EC_1, (F0001 + F0002) / F0003
];

Values:
LOAD * Inline [
KEY, ID, VALUE
EC_1, F0001, 10
EC_1, F0002, 20
EC_1, F0003, 20
];

Join:
NoConcatenate
LOAD * Resident Values;

Inner Join LOAD * Resident Formula;

DROP Table Formula;
DROP Table Values;

[sudeep_d]

join:

load *,1 as dummy

resident values;

left join

load *,1 as dum

resident formulas;

drop fields dummy,dum;

[#7]

Both work. Many thanks!