Forum Discussion

T-Pan's avatar
T-Pan
Icon for Helper I rankHelper I
2 years ago
Solved

Get data from folder issue.

Hello everyone, on my job i have to create a report which will be updated daily with the excels in picture below. As you will see, all columns of these excels have the same Column names except the se...
Need Help
  • T-Pan's avatar
    T-Pan
    2 years ago

    spinfuzer m_dekorte , in tranform sample query, i deleted the promote to headers step and add another step of "delete the first row". So now i have column 1, column 2, etc,  as headers and in my appended query  renamed the columns as i want. I don't know if its the right way but it works.

T-Pan's avatar
T-Pan
Icon for Helper I rankHelper I
2 years ago

spinfuzer m_dekorte , in tranform sample query, i deleted the promote to headers step and add another step of "delete the first row". So now i have column 1, column 2, etc,  as headers and in my appended query  renamed the columns as i want. I don't know if its the right way but it works.

spinfuzer's avatar
spinfuzer
Icon for Solution Sage rankSolution Sage
2 years ago

That sounds good.  All you need to do is make sure you have the same column names one way or another.