- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Actually I cant, Its quite confidential.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there any way we can join the content of two table without applying join or apply map?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have applied these two functionalities, but not getting the accurate data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That depends on what you're trying to do.
talk is cheap, supply exceeds demand