Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pooja821
Creator
Creator

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
Gysbert_Wassenaar

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
Creator
Creator
Author

Actually I cant, Its quite confidential.

pooja821
Creator
Creator
Author

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.

Gysbert_Wassenaar

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
Specialist III
Specialist III

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
Creator
Creator
Author

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

pooja821
Creator
Creator
Author

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

Gysbert_Wassenaar

That depends on what you're trying to do.


talk is cheap, supply exceeds demand