Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I
Helper I

How to make different columns can be continued into 1 column and shown in a new table (Not combine)

Hi experts:

      The inspectors will input the below original table every day, I hope to create some charts in Report View page to show the defects quantity changes by the inspection date, product name, product type, so I need to create a new table, the new table will create rows by each defect, you can refer to the new table, because there are 9 defects in total in the original table, so the new table will have 9 rows, could you help check how to create the new table? 


Original Table

Inspection DateProduct NameProduct TypeDefect 1Defect 2Defect 3Defect 4
2023/1/1ASwitchBox BrokenSoldering FailLow BatteryProduct Scratch
2023/1/2ASwitchLow batteryProduct Scratch  
2023/1/3BMouseProduct broken Low battery  
2023/1/4BCableCable Disconnected   



New Table

Inspection DateProduct NameProduct TypeDefect 
2023/1/1ASwitchBox Broken
2023/1/1ASwitchSoldering Fail
2023/1/1ASwitchLow Battery
2023/1/1ASwitchProduct Scratch
2023/1/2ASwitchLow battery
2023/1/2ASwitchProduct Scratch
2023/1/3BMouseProduct broken
2023/1/3BMouseLow battery
2023/1/4BCableCable Disconnected



Super User
Super User
Super User
Super User

you need to make a duplicate of the table and then delete the unnecessary column and do what was shown in the video

Super User
Super User

Hi Ahmedx:

   Thank you very much for the reply! It's clear for me now!!!

   But I still have a question, I don't want to edit the data in the original table, because there are multiple columns in it, so I want to create a new table only contains the Inspection Date/Product Name/Product Type/Defect, could you help tell me how to make it?

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric certifications survey

Certification feedback opportunity for the community.