Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: New Field Creation Out of Two fileds

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?

Highlighted

Re: New Field Creation Out of Two fileds

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

Highlighted
Creator II
Creator II

Re: New Field Creation Out of Two fileds

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

Highlighted
Creator II
Creator II

Re: New Field Creation Out of Two fileds

in this case, it will create duplicate record

Highlighted

Re: New Field Creation Out of Two fileds

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

Highlighted

Re: New Field Creation Out of Two fileds

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