关于在相同的UID 对于不同username 的check (EXCEL vlookup)

In IBM GPFS file system of finacle, one shared file's owner can be considered different because the different user_name corresponded the same UID.

For example:

In Server A:
UID User_name
101 XiaoZhang

In Server B:
UID User_name
101 XiaoWang

In Server C:
UID User_name
101 XiaoLi

So if the file is uploaded by user XiaoZhang from Server A,
from Server B, the file owner is considered as XiaoWang,
from Server C, the file owner is considered as XiaoLi,
because the file's owner's UID is same (101), which is only considered by the server.

Follow Action:

In order to find out how many user and which is used for the GPFS file system:
I conduct the Microsoft Excel to list the IDs:

In the Excel, two function can be used: IF and Vlookup

1: " IF function" is used to check under the condition and reply with the defination message:

IF Function:
IF( logical_test,[value_if_true],[value_if_false])

example:
A     B
101 shanghai
102 suzhou
103 beijing


=IF(A2=101,"this value is correct","this value is not correct")

Reply message:
"this valueis correct"

2: " Vlookup function" is used to look for the detincation value and return to the detination index colume.

Vlookup Function:
vlookup(lookup_value,table_array,col_index_num,[rang_lookup])

example:

Sheet1:
A     B
101 shanghai
102 suzhou
103 beijing


Sheet2:
A     B
101 shanghai
102 tianjing
103 beijing

In sheet1, use vlookup to perform:

=VLOOKUP(A2,Sheet2!A2:B5,2,0)

3: conbime the IF function and vlookup function:

=IF(B2=VLOOKUP(A2,Sheet2!A2:B5,2,0),"same","different")

4： list the result:
same
different
same

Above result is expected, success.

You can try to enjoy your testing.