Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Combine and filter multiple Date/Time and data columns

This may or may not be compliated but I am new to power query and am still learning. I have a set of data that is a combination of 12 individual equiptment data columns, but each equiptment data has ...
Need Help
KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
4 years ago

Hi Anonymous ,

 

I have a few clarification questions:

  • Is the data provided for equipment 1 / 2 /3?
  • What is the expected value for the first screenshot?

I have a go with the provided data, and I have Part 1 Time that I then split into Date and Time, which returned Part 1 Date, Part 1 Time, Part 2 Date, Part 2 Time ....... So once you clarify the questions above, I'll provide you a step-by-step solution.

 

Regards

KT

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    The data provided is a small sample from 1 equipment. Once I can figure out 1 of them I can then apply it to the others.

    The first screenshot shows that the times are not the same so it's not possible to just delete the extra date/time columns.

     

    So I want to only have 1 date column and one time column per equipment. Each equipment has 8 parts and each part has its own set of Date/Time. You could make each part into its own table, but then you would have too many tables (20 equipment * 8 parts = 160 tables). So in my reply I tried giving an example of how I am trying to organize it. 

    1. Each equipment has its own table

    2. Each table has 8 parts

    3. Each table has 1 Date and 1 time column