topic Re: $orphan table while using ALIAS in QlikView

$orphan table while using ALIAS

Anonymous — Tue, 30 Jun 2015 08:01:44 GMT

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?

Re: $orphan table while using ALIAS

rubenmarin — Tue, 30 Jun 2015 15:23:15 GMT

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;

Re: $orphan table while using ALIAS

marcus_sommer — Tue, 30 Jun 2015 15:23:18 GMT

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

- Marcus

Re: $orphan table while using ALIAS

Anonymous — Wed, 01 Jul 2015 05:36:41 GMT

Hi all,

Please have a look over attached documents.

It consist of script and screenshot of table structure.

Re: $orphan table while using ALIAS

rubenmarin — Wed, 01 Jul 2015 06:06:51 GMT

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;

Re: $orphan table while using ALIAS

marcus_sommer — Wed, 01 Jul 2015 06:08:33 GMT

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

table:

Load City as Ceeti, * Inline [

....

- Marcus