Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Load XLSX From Folder Causing Loss Of Data Due To Case Of Headers

Currently loading from a folder all of the XLSX monthly files from a vendor.  Occassionally the vendor will send the headers in lower case instead of UPPER case.  When this occurs the Transform funct...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

Can you please share us some screenshots? How do you create "Invoke Custom Function1"? The function of Table.TransformColumns will not remove the data. So I think your problem might be caused by the step of "Invoke Custom Function1".

 

Best Regards,

Xue Ding

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Here are the screen shots, thanks for your assistance.  Let me know if they need more explanation.