Forum Discussion
Data processing, all values in one column
Hi! It sounds like you could use the Pivot option in Power Query. Here is a link to details about it. Pivot columns - Power Query | Microsoft Learn
Hello, thanks for your response, but I had already tried it, and I just tried it again and it's not working. Columns aren't being generated correctly, and it's seems like too many data is created. Any way I could use relations to make this work?
Can you share an example or your data by uploading the pbix?
I had to change data because of company policy.
Basically, there are two days in the date column, and each day there are several job_names, that are different job reports. Each job_name has several step_names, and each step_name has several field_values, but also, some field_values are in different step_names.
asically the structure of our report is
Job
-Step
+field 1
+field 2
-Step
+field 3
+field 1
https://drive.google.com/file/d/1psuJIU5vp9PZLKRq5r7NvZ4bhXi-TtWa/view?usp=drive_link
So I want to ideally transform each job_name into one row, with columns for each field_value, but having the same field name in different step names can dificult this. So I wondered if you could assimilate this using relations, so that when I segment any visual into the day (that is introuced as a field in Field_value,and therefore doesn't appear in every row), basically creating a relation between a Job_name and a day
If I understand you correctly, you want to split job_name apart, correct? To do this you can go into Power Query, click on that field and split the column. You can choose to split by delimiter and then choose : for teh delimeter and select once far left - this will put Recogida de Datos formato in one column and everything else into a second. Next, click on teh new column that was created and split that column, this time split by a space and do once as far left. This will give you the values of 120995, 144221, etc. in a column. Next click on the new column that should have ABC Dia: and the date in it. You can split this on space as far right as possible and it will give you your date in a column all by itself. Hope this helps!
That is not what I asked, thank you anyways