topic Re: Field names when loading from a database directly in App Development

Field names when loading from a database directly

ShellyG — Tue, 27 Apr 2021 11:28:41 GMT

Hi there,

I am currently creating my own QVDs in Qlik Sense and I encounter a behavior which doesn't exactly fit my requirements.

When I load my fields from the database, I put a name for the table above the fields as usually, but what happens is that when I load the data, all the fields have the name of the table in front. Is there a way to avoid that but also having a name for your table?

Example:

I load this:

H_TI:
LOAD

Group,
Date,
Order,

And then in the results my field names are:

H_TI.Group

H_TI.Date

and etc...

Thanks in advance!

Best Regards,

Silviya

Re: Field names when loading from a database directly

Dalton_Ruer — Tue, 27 Apr 2021 13:23:11 GMT

My guess is that you have a Qualify * in your code somewhere prior to loading the table. It fully qualifies the field names. Typically people use that to quickly load data from tables that have a lot of field names in common which causes a synthetic join.

When loading data from the database you can rename the fields manually as needed to avoid the problems.

Customer:

Load

Name as [Customer Name],

Address as [Customer Address]

Phone as [Customer Phone];

SQL Select Name, Address, Phone from Customer;

Locations:

Name as [Sales Location Name],

Address as [Sales Location Address],

Phone as [Sales Location Phone];

SQL Select Name, Address, Phone from Locations;

Re: Field names when loading from a database directly

ShellyG — Wed, 28 Apr 2021 12:04:36 GMT

Hi Dalton,

Thanks for your answer.

Indeed I had Qualify * in a previous sheet and when I did the Unqualify it seems I forgot to add the *.

Thanks!