In my data field I have the leading 0 missing that I receive in excel and due to this I am unable to get the correct result.
012344444444 is represented as 12344444444.
How would I join this data?
Try this in your table where you need zvero use Num(Cola,'000000000000') as NewField
LOAD *,Num(Cola,'000000000000') as NewField;
LOAD * Inline
Retrieving data ...