2401_zh-TW
同時從2個數據表中訪問2個具有相同名稱的列我有兩個數據文件,按設計,具有相同的列名。如何引用IF語句中的每一列,以避免含糊不清的引用...
我希望能夠做這樣的事......
IF(dt1.weight == dt2.weight,Re:從2個數據表中同時訪問2個具有相同名稱的列
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-size:10pt; color:black; font-family:Helvetica,Arial,sans-serif;”>你
可以使用列功能
style =“font-size:10pt; color:navy; font-family:Helvetica,Arial,sans-serif;”>:
style =“font-size:10pt; color:black; font-family:Helvetica,Arial,sans-serif;”>
style =“font-family:Helvetica,Arial,sans-serif;”>
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-size:10pt; font-family:”Courier New“; color:black;”> c1
style =“font-size:10pt; font-family:”Courier New“; color:navy;”> =
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-size:10pt; font-family:”Courier New“;顏色:rgb(0,0,221);”>列
style =“font-size:10pt; font-family:”Courier New“; color:black;”>(
style =“font-size:10pt; font-family:”Courier New“; color:black;”> dt1
style =“font-size:10pt; font-family:”Courier New“; color:navy;”>,
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-size:10pt; font-family:”Courier New“;顏色:紫色;”>“重量”
style =“font-size:10pt; font-family:”Courier New“; color:black;”>)
style =“font-size:10pt; font-family:”Courier New“; color:navy;”>;
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
風格=“”>
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
風格=“”>
style =“font-size:10pt; font-family:”Courier New“; color:green;”> //
表dt1中的重量列
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-size:10pt; font-family:”Courier New“; color:black;”> c2
style =“font-size:10pt; font-family:”Courier New“; color:navy;”> =
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-size:10pt; font-family:”Courier New“;顏色:rgb(0,0,221);”>列
style =“font-size:10pt; font-family:”Courier New“; color:black;”>(
style =“font-size:10pt; font-family:”Courier New“;顏色:黑色;”> dt2
style =“font-size:10pt; font-family:”Courier New“; color:navy;”>,
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-size:10pt; font-family:”Courier New“;顏色:紫色;”>“重量”
style =“font-size:10pt; font-family:”Courier New“; color:black;”>)
style =“font-size:10pt; font-family:”Courier New“; color:navy;”>;
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
風格=“”>
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
風格=“”>
style =“font-size:10pt; font-family:”Courier New“; color:green;”> //
表dt2中的重量列
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-size:10pt; font-family:”Courier New“; color:black;”> c1
style =“font-size:10pt; font-family:”Courier New“; color:navy;”> <<
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
設置已選中
style =“font-size:10pt; font-family:”Courier New“; color:navy;”>;
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
風格=“”>
style =“font-size:10pt; font-family:”Courier New“; color:green;”> //
選擇表dt1中的列權重
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-size:10pt; line-height:115%; font-family:”Courier New“; color:black;”> c2
style =“font-size:10pt; line-height:115%; font-family:”Courier New“; color:navy;”> <<
style =“font-size:10pt; line-height:115%; font-family:”Courier New“;顏色:黑色;”>
設置已選中
style =“font-size:10pt; line-height:115%; font-family:”Courier New“; color:navy;”>;
style =“font-size:10pt; line-height:115%; font-family:”Courier New“;顏色:黑色;”>
風格=“”>
style =“font-size:10pt; line-height:115%; font-family:”Courier New“; color:green;”> //
在dt2中選擇列權重
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
style =“font-family:Helvetica,Arial,sans-serif;”>
問候,
style =“font-family:Helvetica,Arial,sans-serif;”>
style =“font-family:Helvetica,Arial,sans-serif;”>彼得
style =“font-size:10pt; font-family:”Courier New“; color:black;”>
Comments
There are no comments yet