Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My data looks like this as below.
Customer ¦ Product number ¦ Date
A 222222 10/11/2011
B 222222 11/11/2014
C 233334 10/07/2015
D 233334 10/08/2014
My output should be like this below.
So basically if the same product number then it should display only the latest date with the customer detail. No old record should be shown.
I tried couple of ways using expression but it shows all the records and only highlights the latest one/.
Please advise here.
What I don't understand is, what do you mean by search using customer?
Hi Sunny,
This issue resolved. Your code was very help ful. the question was for another report which has the same kind ..but here 3 tables are involved.. i will try to figure it out else will post a new discussion
Great, If you got what you were looking for right now... I would suggest closing this thread by marking correct answer and any helpful answers.
Best,
Sunny
how do I do this. where is the option I don't find?
Hi sunny,
Probably you can help me her also.
My scenario looks like this I need to RELATE 3 tables. but it is going to loop.
Table 1:
MAPPING LOAD DISTINCT
Prod Id,
Cust Id
from CustItem Table;
Map:
Load
Id,
few columns....
ApplyMap('Table1', Id) as Cust Id ---- So here I want to map Id and ProdId together
from Product Table
Now I want to take the output of apply map -- I,e Cust Id to join as automatically based on column as below
Id as Cust Id
few columns
...
..
from Customer Table.
Can you share some sample data with your expected output? I don't really understand what you are trying to do here.
hi sunny,
I was able to solve it now.. where should I say this topic is correct? and close it
For Correct Answers:
For Helpful Answers:
