Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

$orphan table while using ALIAS

While doing INLINE Load, if I use ALIAS keyword to rename a field name, It is getting renamed properly whereas if I use QVD Load and use ALIAS, I am getting one more table named as "$orphan_RenamedField". but field in original table is not getting replaced with new name.

I have following questions:

     1. Am I doing anything in wrong way?

     2. What is that "$orphan_" table?

     3. Why the filed is not getting renamed in the original table itself?

5 Replies
rubenmarin

Hi Kushal, I don't know why but doing an optimized load of a qvd and use an alias can turn in that issue. To avoid that use a condition on load:

LOAD ... FROM ... (qvd) Where 1=1;

or load your qvd optimized and then use rename:

RENAME Field OriginalFieldName to NewFieldName;

marcus_sommer

Please post your load-script and a screenshot from tableviewer.

- Marcus

Anonymous
Not applicable
Author

Hi all,

Please have a look over attached documents.

It consist of script and screenshot of table structure.

rubenmarin

Hi Kushal, instead of alias you can set the alias when loading qvd:

LOAD .....

     City as Ceeti

.....

FROM ... (qvd);

or use rename after loading:

LOAD .....

.....

FROM ... (qvd);

RENAME Field City to Ceeti;

marcus_sommer

The rename of the fields must be inside the load like:

table:

Load City as Ceeti, * Inline [

....

- Marcus