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.

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

Edit the Sample File.

Demote Headers

Extract Text After Delimiter Space on the second column

Promote Headers.  The column name is now just "Missing".

  • 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.

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

      You need to edit the Transform Sample Query and edit the Main Query because the Main Query might be broken because the column name(s) are different.   You can probably just delete the steps with errors.