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: 
meetmrudul
Creator II
Creator II

New Field Creation Out of Two fileds

Hi Gurus,

I have a standalone table in my table, as its having less number of records.

I have User Details as old user, new user, I would like to merge them into one column as User, so that I can use the same as dimension.

Could you please provide your inputs for same.

Thanks & Regards,

MK

6 Replies
sunny_talwar

meetmrudul wrote:

I have a standalone table in my table, as its having less number of records.

Having difficulty visualizing this. Do you have a sample you can provide? or few lines of sample data and your expected output?

Kushal_Chawda

Concatenate Table by creating Flag as old and New user

Data:

LOAD  [OLD USER] as User,

            'OldUser' as Flag

             ......

FROM Table

concatenate(Data)

LOAD  [NEW USER] as User,

           'NewUser' as Flag

            ......

FROM Table

meetmrudul
Creator II
Creator II
Author

I have a standalone table in my datamodel, as its having less number of records.

meetmrudul
Creator II
Creator II
Author

in this case, it will create duplicate record

sunny_talwar

Can you show your datamodel? What do you mean when you say stand alone table?

avinashelite

please share the sample data set and required output so that we can help you out with the same