Concatenating two fields from same table.

[ajsjoshua]

Dear all,

I have two fields which has sales person details for  Vinegar and non vinegar.Now i want to combine both Vinegar and non vinegar as vin.

I tried this method

TABLE1:

load

customer,

fn,

res,

Vinegar as vin

load

customer,

fn,

res,

non vinegar as vin

Is there is a better approach to do it.

Thanks & Regards,

Joshua.

[YoussefBelloum]

it is pretty simple transformation, keep it simple, I would have done the same