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