in script write this
LOAD * INLINE [
ID, Class, Dept, Indicator
A, C1, MKT, Good
B, C2, HR, Bad
C, C1a, MKT, Good
D, C2a, MKT, Good
LOAD *,Class as Class_new INLINE [
then in straight table--
expression1=if(Class=Class_new, Dept,' ')
THEN OUTPUT LIKE THIS
ID Class Dept Indicator - A C1 MKT Good B C2 HR Bad C C1a Good D C2a Good
join_comm.qvw 156.0 K
i found the ansewers for myself and i know how to work.
First, creaet a outer join table
Second, create a temp table to store the Primary key.
Third, resident the outer join table, update column value by using if statment and exists function together.
Then, we can drop the table.
Many thanks all of you to give me advice.
Thank you very much