Fields renaming

[Anonymous]

Hi,

I'm working on an unknow database and I need to rename fields in order to avoid synthetic keys.

What I know is that I can rename a field by the    FIELD_NAME as  NEW_FIELD_NAME, but field by field only.

Is there a way to rename all fields adding a prefix or a suffix, without spend a lot of time with the "field by field renaming" ?

Thanks in advance

Bibo

[whiteline · Accepted solution]

Yes. Qualify.

Add before your load:

Qualify *;