Forum Discussion
Help with Data transformation
I have exported data from. csv files to Power BI. One of the columns contains text values ( product description) and is getting dispersed across other columns. It looks the same in excel as well. Is ...
PhilipTreacy
Super User
Super UserHi Anonymous
If your source data is getting split across columns incorrectly then there's either something wrong with the format of the source CSV, or the import of the dfata is incorrect, or both.
Can you please share a sample CSV file?
Regards
Phil
Thanks for your prompt reply. Here is sample data that represents how the data is stored. Please kindly let me know how I could rectify this issue with the csv file. Thank you !
| ProductDescription | OnHoldCode | OpTime$ | PlannedOpQty | Workshop | ScheduleLocked | Priority | Complete | ProjectCode | DateCompleted | StatusCode | EarliestStartDate | ResourceCode | ProductGroup | DateRequired | QuantityInStock | |||||||
| ------------------ | ---------- | ------- | ------------ | -------- | -------------- | -------- | -------- | ----------- | ------------- | ---------- | ----------------- | ------------ | ------------ | ------------ | --------------- | |||||||
| MT | MOTOR | PLATES ASSEMBLY (RH) | 00:00:00 | 40 | GL | No | 0 | No | AM | NULL | 5 | NULL | SUB NDT | 00:00.0 | 3 | |||||||
| PL WING | 00:00:00 | 44 | GL | No | 0 | No | NULL | 7 | NULL | SUB NDT | 00:00.0 | 0 | ||||||||||
| CH ASSEMBLY + CP564565 | 00:00:00 | 3 | SM | No | 0 | No | NULL | 7 | NULL | SUB NDT | 00:00.0 | 0 | ||||||||||
| BU - Concession 3000012013 & 5000016448 | 00:00:00 | 50 | GL | No | 0 | No | NULL | 7 | NULL | SUB NDT | 00:00.0 | 32 | ||||||||||
| MM Housing | 00:00:00 | 8 | GL | No | 0 | No | NULL | 7 | NULL | SUB PLT | 00:00.0 | 174 | ||||||||||
| CNG LINK | RIGID | SAU | 00:00:00 | 30 | GL | No | 0 | No | NULL | 7 | NULL | SUB NDT | 00:00.0 | 6 | ||||||||
| PIN | CLEVIS | LINKAGE | 00:00:00 | 2 | SM | No | 0 | No | NULL | 7 | NULL | SUB HT | 00:00.0 | 0 |