Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
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