Help need in Alt function

[Anonymous]

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)

[sunny_talwar]

How is History table and Current table connected to one another? I don't see any common fields here

[trdandamudi]

I don't see any relation, Am I missing something here ?

[marcus_sommer]

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