Discussion Board for collaboration related to QlikView App Development.
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?
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;
Please post your load-script and a screenshot from tableviewer.
- Marcus
Hi all,
Please have a look over attached documents.
It consist of script and screenshot of table structure.
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;
The rename of the fields must be inside the load like:
table:
Load City as Ceeti, * Inline [
....
- Marcus