Forum Discussion

ET2018's avatar
ET2018
Frequent Visitor
8 years ago
Solved

Append queries problem

I tried to append 2 tables with identical columns.  However, the appended queries created a new date column.   Seems date column of 2 tables cannot be appended, how to fix this issue?     ...
Need Help
  • johnmu's avatar
    johnmu
    8 years ago

    The queries reference local files, so I can't try resolving this in the Query Editor,

     

    But if you create a calculated table based on your two source tables

     

     

    Union Table = UNION('Data_ISS ECP','Data_Lo''s WAS')

    That looks like it works just fine to me

     

     

    Edit: I also see the following in the applied steps (again, can't see the data to confirm) but it looks like it might be part of the issue.

     

    For the "Changed Type" step in both tables, the date column is handled differently. For ISS ECP you have 

     

    = Table.TransformColumnTypes(#"Promoted Headers",{{"Month", Int64.Type}, {"Date#(lf)", type date}, ...

    And for Lo's WAS you have

     

    = Table.TransformColumnTypes(#"Promoted Headers",{{"Month", Int64.Type}, {"Date", type date},

    It looks like you tried to modify the type for Lo's WAS but not ISS ECP. and Lo's WAS has a slightly different date name (Date#(lf) instead of Date). Pretty sure the #(lf) stands for 'line feed' and is one of the hidden characters I was referring to in the last post.

johnmu's avatar
johnmu
Helper I
8 years ago

The queries reference local files, so I can't try resolving this in the Query Editor,

 

But if you create a calculated table based on your two source tables

 

 

Union Table = UNION('Data_ISS ECP','Data_Lo''s WAS')

That looks like it works just fine to me

 

 

Edit: I also see the following in the applied steps (again, can't see the data to confirm) but it looks like it might be part of the issue.

 

For the "Changed Type" step in both tables, the date column is handled differently. For ISS ECP you have 

 

= Table.TransformColumnTypes(#"Promoted Headers",{{"Month", Int64.Type}, {"Date#(lf)", type date}, ...

And for Lo's WAS you have

 

= Table.TransformColumnTypes(#"Promoted Headers",{{"Month", Int64.Type}, {"Date", type date},

It looks like you tried to modify the type for Lo's WAS but not ISS ECP. and Lo's WAS has a slightly different date name (Date#(lf) instead of Date). Pretty sure the #(lf) stands for 'line feed' and is one of the hidden characters I was referring to in the last post.

  • ET2018's avatar
    ET2018
    Frequent Visitor
    8 years ago

    thanks.

     

    As I have more than 2 tables so Union can't help.

     

    I changed the header again in edit query, working now.

    • johnmu's avatar
      johnmu
      Helper I
      8 years ago

      Glad to hear it. FYI, you can use UNION with more than two tables. Still if you can resolve this at the Query Editor I think that's better.

      • ET2018's avatar
        ET2018
        Frequent Visitor
        8 years ago

        OMG.

         

        Actually, I never tried UNION for 2+ tables, as the description said 2 tables. 

  • Alphatooth's avatar
    Alphatooth
    Frequent Visitor
    3 years ago

    Thanks for the solution, it worked. But I can't view this union table in the power query editor to make few changes. How can I make this table viewable in the editor ?