Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get table name

Hello everyone,

Actually I try to get the name of what I LOAD to another table:

Table I want to get the name:

CONCATENATE(NAME)

       LOAD A AS "FIELD1",

                 B AS "FIELD2",

                 C AS "FIELD3",

Regards

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

NAME:

LOAD A AS "FIELD1",

                 B AS "FIELD2",

                 C AS "FIELD3",

                  "NAME" As TableName

From NAME;

CONCATENATE(NAME)

       LOAD A AS "FIELD1",

                 B AS "FIELD2",

                 C AS "FIELD3",

                  "Name2" As TableName

From Name2

View solution in original post

3 Replies
jsanchezh
Partner - Creator
Partner - Creator

When you concatenate, your are adding these fields to your table called NAME.

You can try this:

NAME:

LOAD *

     FROM

MY_NEW_TABLE_NAME:

noConcatenate LOAD A AS "FIELD1",

                 B AS "FIELD2",

                 C AS "FIELD3"

FROM

Then you will have two tables: NAME and MY_NEW_TABLE_NAME but if they have the same field names you will have a synthetic table

Gabriel
Partner - Specialist III
Partner - Specialist III


Hi,

Naming a table is up to you to name the table with name relevant to the data you're loading. i.e. if you are loading Customer data, it make sense to name the table Customer or CUST. So if you're concatenate you just copy same table name above and paste it into the concatenate open and close bracket.

anbu1984
Master III
Master III

NAME:

LOAD A AS "FIELD1",

                 B AS "FIELD2",

                 C AS "FIELD3",

                  "NAME" As TableName

From NAME;

CONCATENATE(NAME)

       LOAD A AS "FIELD1",

                 B AS "FIELD2",

                 C AS "FIELD3",

                  "Name2" As TableName

From Name2