Field names when loading from a database directly

[ShellyG]

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 

[Dalton_Ruer · Accepted solution]

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;

[ShellyG]

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!