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

But again its different Column name from the other Excels as you can see from images.  Will ot work?

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

Is Column2 always "Date Missing"?  Date followed by a space then Missing?  If so, yes, it will work.

 

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

    Yes the format o column 2 name is always the same. I've asked the it department to named it "missing" and create another column with "Date". But demands to IT Department always take a lot of time to be made.