Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

dunnalahk123
Contributor II

Concatenate two objects

Hi,

can some one help me here for below scenario

i have two objects  which i am concatenating

HOLD:

LOAD [Project ID],
     [HOLD Closure date],
     //[HOLD Closure date2],
//     Field_Text,
//     Old_Value_Text,
//     New_Value_Text,
     [PSA Project pse Project ID]
   
FROM
[$(QVD_Path)\GSD_HOLDClosuredate.qvd]
(qvd)

;

Concatenate


LOAD [Project ID],
     //[HOLD Closure date],
     [HOLD Closure date2],
//     Field_Text,
//     Old_Value_Text,
//     New_Value_Text,
     [PSA Project pse Project ID]
      
FROM
[$(QVD_Path)\GSD_HOLDClosuredate2.qvd]
(qvd);

Test.PNG

From above you can see i am getting output in 4 lines but i need it in 2 lines.

can some one suggest me here.

Best Regards,

Hari

12 Replies
Chanty4u
Esteemed Contributor III

Re: Concatenate two objects

you are concatenating the tables not the fields ?

bcz you have two dates for  closure date  and  closure date2   its having two seperate project pse dates

arvind1494
Valued Contributor

Re: Concatenate two objects

HOLD:


LOAD [Project ID],

     [HOLD Closure date],

     //[HOLD Closure date2],

//     Field_Text,

//     Old_Value_Text,

//     New_Value_Text,

     [PSA Project pse Project ID]

   

FROM

[$(QVD_Path)\GSD_HOLDClosuredate.qvd]

(qvd);


JOIN(HOLD)


LOAD [Project ID],
     //[HOLD Closure date],
     [HOLD Closure date2],
//     Field_Text,
//     Old_Value_Text,
//     New_Value_Text,
     [PSA Project pse Project ID]
      
FROM
[$(QVD_Path)\GSD_HOLDClosuredate2.qvd]
(qvd);

dunnalahk123
Contributor II

Re: Concatenate two objects

HI,

IF i Join it's getting duplicated. i tried that option.

best Regards,

HK

arvind1494
Valued Contributor

Re: Concatenate two objects

try inner join

dunnalahk123
Contributor II

Re: Concatenate two objects

HI,

Yes i tried that also, if we use join below is what we are getting

JOin.PNG

dunnalahk123
Contributor II

Re: Concatenate two objects

Hi,

Yes, but i need output in in 2 rows only instead of 4 rows. is that possible.

arvind1494
Valued Contributor

Re: Concatenate two objects

Let me try :

Can you provide data so that i can copy paste it

dunnalahk123
Contributor II

Re: Concatenate two objects

Hi Arvind,

Sorry, what you need from my end , is my QVW application?

arvind1494
Valued Contributor

Re: Concatenate two objects

Try this:


map1:

mapping LOAD

[PSA Project pse Project ID],

     [HOLD Closure date2],     

FROM

[$(QVD_Path)\GSD_HOLDClosuredate2.qvd]

(qvd);



HOLD:

[PSA Project pse Project ID],

     [HOLD Closure date],
    applymap('map1', [PSA Project pse Project ID],'unknown')
FROM
[$(QVD_Path)\GSD_HOLDClosuredate.qvd]
(qvd)