Qlik Table (field concatenation)

bhargavikatari — Tue, 22 Oct 2019 20:02:06 GMT

Hi everyone,

Can some one help me with the table format that I am looking for>?

Here below are the details

Below is the Table I have

LOAD * INLINE [
F1, F2, F3, F4, F5
abc, 123, 12-Oct, 1, sfdi
abc, 233, 13-Oct, 2, fd
abc, 453, 14-Oct, 2, fd
abc, 532, 15-Oct, 1, sdcf
sfsfk, 4332, 12-Oct, 1, as
dekfje, 32437, 13-Oct, 2, fd
dekfje, 432, 14-Oct, 1, fd
sfsfk, 423, 15-Oct, 1, aG
bbn, 53432, 14-Oct, 1, sdffg
bbn, 98909, 13-Oct, 1, sdffg
];

The resultant table should look like the one below. Any help on this would be highly appreciated.

Re: Qlik Table (field concatenation)

treysmithdev — Wed, 23 Oct 2019 01:51:52 GMT

Try this:

LOAD F1 as FieldOne, Pick(F4, F2 & F3) as FieldTwo, Pick(F1, F5) as FieldThree, Pick(F4, Null(), F2 & F3) as FieldFour, Pick(F4, Null(), F5) as FieldFive INLINE [ F1, F2, F3, F4, F5 abc, 123, 12-Oct, 1, sfdi abc, 233, 13-Oct, 2, fd abc, 453, 14-Oct, 2, fd abc, 532, 15-Oct, 1, sdcf sfsfk, 4332, 12-Oct, 1, as dekfje, 32437, 13-Oct, 2, fd dekfje, 432, 14-Oct, 1, fd sfsfk, 423, 15-Oct, 1, aG bbn, 53432, 14-Oct, 1, sdffg bbn, 98909, 13-Oct, 1, sdffg ];

topic Re: Qlik Table (field concatenation) in App Development

Qlik Table (field concatenation)

Re: Qlik Table (field concatenation)