getting error while joining 2 file size of 2 mb and 3 GB

2 次查看(过去 30 天)
hello Everyone!!
i have to join two files, i am using innerjoin with one key column 'XDRID' but am getting the following error.can anybody help me in knowing to why am getting this error and how to solve.
Error using table/innerjoin (line 78)
Left and right key variables 'XDRID' and 'XDRID' are not comparable
because one is a non-cell.
  9 个评论
naadiya khudabux
naadiya khudabux 2016-10-9
consider this as my 2nd table. i am trying to join on the base of 'XDRID'.
naadiya khudabux
naadiya khudabux 2016-10-9
if true
K>> drop.VariableNames
ans =
Columns 1 through 6
'XDRID' 'RAT' 'IMSI' 'IMEI' 'MSISDN' 'MachineIPAddType'
Columns 7 through 12
'SGWGGSNIPAdd' 'TAC' 'ECI' 'APN' 'AppTypeCode' 'RequestTime'
Columns 13 through 16
'ProcedureEndTime' 'ProtocolType' 'AppType' 'AppSubType'
Columns 17 through 21
'AppContent' 'AppStatus' 'USER_IPv4' 'UserPort' 'L4Protocal'
Columns 22 through 25
'AppServerIP_IPv4' 'AppServerPort' 'ULTraffic' 'DLTraffic'
Columns 26 through 29
'ULIPPacket' 'DLIPPacket' 'ULTCPOoOPacket' 'DLTCPOoOPacket'
Columns 30 through 32
'ULTCPRetransPacket' 'DLTCPRetransPacket' 'TCPSYNAtteDelay'
Columns 33 through 35
'TCPSYNComfirmDelay' 'ULIPFRAGPACKETS' 'DLIPFRAGPACKETS'
Columns 36 through 39
'TCPSYNSuccFirstRe…' 'FirstReqToFirstRe…' 'WindowSize' 'MSSSize'
Columns 40 through 43
'TCPSYNAtte' 'TCPConnStatus' 'SessionIsEnd' 'EventType'
Columns 44 through 46
'HTTPWAPStatus' 'FirstHTTPResPacke…' 'LastHTTPPacketDelay'
Columns 47 through 51
'LastACKPacketDelay' 'HOST' 'URI' 'XOnlineHost' 'UserAgent'
Columns 52 through 55
'HTTP_content_type' 'refer_URI' 'Cookie' 'ContentLength'
Columns 56 through 59
'DestBeha' 'OperBehaIden' 'OperFinishIden' 'OperDelay'
Columns 60 through 61
'Browser' 'PortalAppCollection'
end
These are the labels for all the columns

请先登录,再进行评论。

采纳的回答

Walter Roberson
Walter Roberson 2016-10-9
The error message you are getting would be consistent with the first column of the second table being named XDRID, the same as the third column of the first table. However, the third column of the first table is numeric, while the first column of the second table is character vector.
When you do a table join, the fields that have the same name in the two tables must also have the same data type.
  50 个评论
Walter Roberson
Walter Roberson 2016-11-13
I went back to my code, and to the disk1.txt and gaoxiaotest2.txt that you had posted. This time around, I can determine that there are no fields upon which those two files match. Every match was at a location where either the data was missing or the field was 0 or 1. I cross-checked all the combinations.
I do not know now how it is I found matches before; they are not there now when I look.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Environment and Settings 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by