Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Iam trying to join and get data in such a way that
when there is a match for a number from table1 in table2 , I would need to display the fname and lname from table1
and when there is no match for a number, I simply need to show the number from table2
I have attached some sample data.
Please help me with this.
I hope this is what you want, let me know if this does not work for you
Like this??
tab1:
load * inline
[number,fname,Lname
4321,rob,dan
6879,svet,shan
7432,kina,jone
2134,anna,aime
];
join
tab2:
Load * inline
[
number,minutes
12345,10
5678,20
7890,30
4321,5
6879,8
]
;
May be this
if you want to avoid customer numbers in table2 containing fname and lname have no match from table 1 and table 2
Table:
Load * Inline [
number,minutes
12345,10
5678,20
7890,30
4321,5
6879,8
];
Left Join(Table)
Load * Inline [
number,fname,Lname
4321,rob,dan
6879,svet,shan
7432,kina,jone
2134,anna,aime
];
I am trying to create a bar chart
for a certain date
on x-axis I will have to show customer name from table1, if there is a match for number
else , if there is no match for a number, I will have to show only the number from table2.
on y-axis I need to show by timeperiod and dollars. I have attached spreadsheet to my post.
please help with this.
can you please help with this
can you please help with bar chart
Can you post sample output that you are looking for? Please!!!
I attached the file that I was trying to work on. bar chart or combo chart
for a given date , on the x-axis, I need to show name of the person (name from tab1 ...if there is a number match in both the tables).
If there is no number match, I need to show the number itself (from tab2)on the x-axis
on y-axis I need to show count of timeperiod or bill amount
I was wondering what all I need to add in the group and expression.
please help
I hope this is what you want, let me know if this does not work for you
this works amazing
but like yours, how to get denominations of 0,2,...12 on left side of y-axis and 0,50,..100 on right side of y-axis ?
and bars look tiny