Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Isn't there a way in the load script to give table fields a blanket alias versus assigning an alias by going through each field one by one?
What do you mean by a blanket alias? All fields renamed in a similar way, such as stripping off the first two characters and then replacing underscores with blanks? I'm not aware of a way. So far as I know, every field must be given an explicit alias. You can also rename fields after the load with a rename statement, but again, I think every field must be renamed explicitly. I suppose you could consider QUALIFY to be a sort of blanket alias, since you can change the names of all fields in a table at once, but only in a very specific way.
What do you mean by a blanket alias? All fields renamed in a similar way, such as stripping off the first two characters and then replacing underscores with blanks? I'm not aware of a way. So far as I know, every field must be given an explicit alias. You can also rename fields after the load with a rename statement, but again, I think every field must be renamed explicitly. I suppose you could consider QUALIFY to be a sort of blanket alias, since you can change the names of all fields in a table at once, but only in a very specific way.
Qualify is what I was looking for, thanks!!
Thank you! I am just looking for the same.
Hello,
Thanks! I am looking for this.