Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am having below scenario. I am getting Ticket_Numbers from two different tables (Historical & Current). So my pivot table needs to show the either one of the ticket number based on availability
All I need to show from either one of the fields.
History:
F1,F2
AA,T1
BB,T2
Current:
F3,F4
AA,
BB
Expected O/P
F5,F6,Ticket
WW,EE,T1
ER,GH,T2
Note:
I was trying to show Alt(F2,F4)
How is History table and Current table connected to one another? I don't see any common fields here
I don't see any relation, Am I missing something here ?
I think you should concatenate both tables like:
Tickets:
Load F1, F2, 'History' as Source From History;
concatenate
Load F3 as F1, F4 as F2, 'Current' as Source From Current;
and then you would probably don't need a logic like your alt() approach but of course with the Source field you could differ from where your values come from, for example:
count({< Source = {'Current'}>} F1)
- Marcus