Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a field like this in some excel files:
[Province
],
and in some excel i have field like this : [Province]
how to load all files at same time. Right now if i load , it throws error province field not found because of different formats.
You can load columns based on their order @1 if xls file, column letter eg. A if xxls. Like this:
LOAD
A as field1
B as field2
FROM [lib://*.xlsx]
(ooxml, no labels, header is 0 lines, table is [table])
;
Be sure to include no labels in the load.
Sanju, did David's suggestion work for you on this one? If so, be sure to come back and use the Accept as Solution Button to give him credit and let others know that worked. If you are still working on things, leave an update. I cannot think of any better way to go about things than what David described.
Regards,
Brett
Hello.,
Before reload need to change field like this
mid(Province,2,10) as Province
do it in data model