Forum Discussion

marsclone's avatar
marsclone
Helper IV
7 years ago
Solved

Unpivoting goes wrong

Hello,   I have the following situation. I have a folder, with different files. Each file contains numbers from an company. These numbers are shown in different columns per year. The first files h...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    7 years ago

    Hi  marsclone ,

    Since the column of the first file is set to be the standard at the time of import, the default column name is returned when the column name is inconsistent. So you need to re-import the files with inconsistent column names. Then use “Append columns” to get a collection of two tables.

     

    Best Regards,

    Eads

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-eachen-msft's avatar
v-eachen-msft
Community Support
7 years ago

Hi  marsclone ,

Since the column of the first file is set to be the standard at the time of import, the default column name is returned when the column name is inconsistent. So you need to re-import the files with inconsistent column names. Then use “Append columns” to get a collection of two tables.

 

Best Regards,

Eads

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • marsclone's avatar
    marsclone
    Helper IV
    6 years ago

    Hi v-eachen-msft 

     

    With your advice, i made multiple queries and appended them.

    This works.

     

    Thank you!

     

    Regards Marcel