Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pooja821
New Contributor III

Combine Data of columns

I need to compare the data of two table into one columns so as to use it another table.

For eg. I have Band column of 31st  Mar and Band column of 28th Feb.

I need to combine the data of these two column into one so as to use it another able, So that my data changes according to the date selected.

8 Replies

Re: Combine Data of columns

Can you show us a sample of your data and an example of what the result table should look like?


talk is cheap, supply exceeds demand
pooja821
New Contributor III

Re: Combine Data of columns

Actually I cant, Its quite confidential.

pooja821
New Contributor III

Re: Combine Data of columns

I need to create a filter pane with two dates in it.

Now I want is that my data should change with respect to the date I select.

Re: Combine Data of columns

Make up some then. It doesn't have to be confidential to show us what you have to work with and what your trying to do.


talk is cheap, supply exceeds demand
rahulpawarb
Valued Contributor II

Re: Combine Data of columns

Hello Pooja,

According to your business logic you can opt for Concatenate or Join functionality. Below are the examples:

//Join functionality - If you want data from both the sets without duplicates

Table1:

LOAD * INLINE [

Band

1

2

3

4

5

];

JOIN

Table2:

LOAD * INLINE [

Band

3

4

5

6

7

8

];

//Concatenate functionality -- If you want data from both the sets with duplicate values

Table1:

LOAD * INLINE [

Band

1

2

3

4

5

];

Concatenate

Table2:

LOAD * INLINE [

Band

3

4

5

6

7

8

];

Hope this will help.

Regards!

Rahul Pawar

pooja821
New Contributor III

Re: Combine Data of columns

Is there any way we can join the content of two table without applying join or apply map?

pooja821
New Contributor III

Re: Combine Data of columns

I have applied these two functionalities, but not getting the accurate data.

Re: Combine Data of columns

That depends on what you're trying to do.


talk is cheap, supply exceeds demand