Show two fields concatenated in Filterpane Qliksense

[berryandcherry6]

Hi,

I have a script like below

LOAD `batch_meta_data_id`,

    `batch_name`,

client_id;

FROM BATCHMETADATA;

LOAD `client_id`,

    `client_name`;

FROM CLIENT;

Now i need to show batch_name with its client_name appended in Filterpane.  But selection will be same , according to batch name selection. Just i need to append client name to batch name. Without effecting its normal functionality.

Table:

Load * INLINE [

client_name ,batch_name

Biscuits,britania

Biscuits,krackzak

Chocolate,cadbaury

Chocalate,Kitkat

]

In Filterpane when i apply, batch name. Batchname should show along with clientname

Expected Output

Biscuits- britania

Biscuits- krackzak

Chocolate- cadbaury

Chocalate- Kitkat

[kakani87]

Can you post some sample data

[berryandcherry6]

Have updated question please check.

[kakani87]

Something like this ??

[berryandcherry6]

Image is too small, its not clear

[kakani87 · Accepted solution]

Try This Script

Batch_Table:

Load * INLINE [

client_name ,batch_name

Biscuits,britania

Biscuits,krackzak

Chocolate,cadbaury

Chocalate,Kitkat

]

;

Final:

load *, batch_name&'-'&client_name as Batch_Client

Resident Batch_Table

;

DROP Table Batch_Table

;

[kakani87]

when ever you find an image  in the post kindly click on that and a pop up opens showing the image