Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Want to create new field with data of 3 existing fields

Hello Friends,

I have 3 different fields count1,count2 and count3. Now, i want all these 3 fields under one field  "Count"

I have the following fields

Count1     Count2       Count3

-----------   -------------   -----------------

125            231            98

Now i want

Count-Name   Count

---------------------------------

  Count1           125

  Count2           231

  Count3            98

Any help is greatly appreciated.

13 Replies
Not applicable
Author

I am sorry Jens Frederik,

I am getting the error as   "Field not found - <Count1>"

Thanks a lot

Not applicable
Author

Vishwaranjan, Sorry to say that i am not using any flat files, i am just connecting to DB and by query i am fetching the fields.

Thanks a lot for your reply.

jfkinspari
Partner - Specialist
Partner - Specialist

Okay, I see that count1 in the SQL statement and Count1 in the LOAD statement uses an upper and lower 'c'. That's causing the error.

Not applicable
Author

But i have given same case in SQL statement and LOAD statement as well.