topic Re: Concatenate two objects in QlikView

Concatenate two objects

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

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);

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

Re: Concatenate two objects

Chanty4u — Wed, 01 Aug 2018 11:03:59 GMT

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

Re: Concatenate two objects

arvind1494 — Wed, 01 Aug 2018 11:07:33 GMT

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)

Re: Concatenate two objects

dunnalahk123 — Wed, 01 Aug 2018 11:20:12 GMT

HI,

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

best Regards,

Re: Concatenate two objects

arvind1494 — Wed, 01 Aug 2018 11:21:54 GMT

try inner join

Re: Concatenate two objects

dunnalahk123 — Wed, 01 Aug 2018 11:25:00 GMT

HI,

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

Re: Concatenate two objects

dunnalahk123 — Wed, 01 Aug 2018 11:26:16 GMT

Hi,

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

Re: Concatenate two objects

arvind1494 — Wed, 01 Aug 2018 11:27:13 GMT

Let me try :

Can you provide data so that i can copy paste it

Re: Concatenate two objects

dunnalahk123 — Wed, 01 Aug 2018 11:32:31 GMT

Hi Arvind,

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

Re: Concatenate two objects

arvind1494 — Wed, 01 Aug 2018 11:36:30 GMT

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)

Re: Concatenate two objects

dunnalahk123 — Wed, 01 Aug 2018 11:48:49 GMT

Hi,

map1:

mapping LOAD
[PSA Project pse Project ID],
[HOLD Closure date2]
FROM
[$(QVD_Path)\GSD_HOLDClosuredate2.qvd]
(qvd);

HOLD:

LOAD

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

But Second field "T" is coming same date for both 2 rows. which it should not be as per below snashot

Re: Concatenate two objects

dunnalahk123 — Wed, 01 Aug 2018 12:22:34 GMT

Hi,

As per Apply map function properties in serves data in first come first serve order.

But what to do if there are different value for same id

And how to get the second referring value for the same.

Re: Concatenate two objects

neelamsaroha157 — Wed, 01 Aug 2018 14:03:27 GMT

The thing is that system doesn't know which Closure date corresponds to Closure date2 and its creating four rows.

If you have a logic to say that 9/20 should be placed against 9/29 or 8/16 then it may work.