Combine Data of columns

[pooja821]

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.

[Gysbert_Wassenaar]

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

[pooja821]

Actually I cant, Its quite confidential.

[pooja821]

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.

[rahulpawarb]

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]

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

[pooja821]

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

[Gysbert_Wassenaar]

That depends on what you're trying to do.