Hi!
This will most likely be a very easy newbie question, but I haven't been able to successfully Google it.
In this example, I want to load the whole [EXT_Person] table as [Person], but I also need to rename the [Id] field. This example solves the code problem:
Person:
LOAD
Id AS %Person_Id,
*
RESIDENT EXT_Person;
DROP FIELD Id;
DROP TABLE EXT_Person;
However, I would like to load the fields like this, i.e. listing all the fields one by one:
Person:
LOAD
Id AS %Person_Id,
FirstName,
LastName,
... etcetera ...
RESIDENT EXT_Person;
DROP TABLE EXT_Person;
My question is this: In the Qlik Sense Enterprise user interface, is there a way to do this load without having to type in all the field names manually? In my example I only need to rename one field, but having to rename multiple fields and then dropping them one by one is not pretty.
One slightly less cumbersome (but still rather clumsy) way to achieve this woud be to load the table from the Connection dialog once more (which would give me a full SQL SELECT and LOAD script) and then remove the SQL SELECT part. Note that the %Person_Id field is a key (it won't be unique), which (if I understand correctly) rules out the RENAME function.
I wish you all a great day!
