Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to perform the following operation:
Can this be performed? If so, how?
Caveat: after I load the data the first time, I cannot reload the data again.
I'm thinking about a straight table where an expression based on a series of nested if() creates a flag for each of the ID, however as the list of ID grows (20-50-100) the nesting becomes impractical.
Thanks in advance for your help.
Pat
Hi,
PFA file for solution. Hope it helps you.
Regards,
Jagan.
Hi Jagan
the inline and findvalue definitely help but only solve half of the issue.
As of now, the tool is able to select 1 of the set of n options in the table and list it in the straight table.
What I need to do is:
Step 1 and 2 seem just a duplicate of what you did. I'm not sure how to include the 3rd in the expression in the straight table.
Thanks
Pat