Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
Can some one share with me , am i allow to rename field name by below load script for Column1 ?
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"
Solved! Go to Solution.
Hi @Paulyeo11 ,
No. The name should be the same in the previous step.
You could only Rename column after applied steps to avoid inconsistent names .
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hi @Paulyeo11 ,
No. The name should be the same in the previous step.
You could only Rename column after applied steps to avoid inconsistent names .
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hi Sir
Thank you very much. What software you use to create the video ?
@Paulyeo11 , Only if the name has changed in source file. Otherwise you should not change it
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |