Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

load Int64.Type as type text first , what are consequences ?

Hi All

 

it is advisable for me to load Int64.Type as type text first ? what are consequences ?

 

let
Source = Csv.Document(File.Contents("C:\Users\pauly\Dropbox\QV_RAW_ISDN\AR_TS_10.txt"),null,{0, 9, 99, 119, 126, 161},ExtraValues.Ignore,1252),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type date}, {"Column4", Int64.Type}, {"Column5", type text}, {"Column6", type text}})
in
#"Changed Type"

  • Anonymous , if it is integer then you should load as int64.type. Otherwise it is additional transformation

1 Reply

  • Anonymous , if it is integer then you should load as int64.type. Otherwise it is additional transformation