scpournara
New Member
- Joined
- Aug 24, 2014
- Messages
- 45
2 transformations I need to complete in Power Query.
1) I am appending multiple .cvs file. The source Name is "AvailableInventory - 08102020.cvs". I can not seem to Add column and extract the "08102020" and create a Date format? Can anyone help?
2) I have thousands of rows of data that express values in both FT and LBS. SAmple data looks like this: (25,645 LB, 10,000 FT, 31,500 LB). Imported the format is ABC 123. I can create new column for FT and LBS, but can not seem to create a new column with the number and change format to a whole number? Help?
1) I am appending multiple .cvs file. The source Name is "AvailableInventory - 08102020.cvs". I can not seem to Add column and extract the "08102020" and create a Date format? Can anyone help?
2) I have thousands of rows of data that express values in both FT and LBS. SAmple data looks like this: (25,645 LB, 10,000 FT, 31,500 LB). Imported the format is ABC 123. I can create new column for FT and LBS, but can not seem to create a new column with the number and change format to a whole number? Help?
