Allan Vittrup
Activity
Posts, comments, and community contributions
Comments
-
Hi again. I'm afraid that I need that very concrete example to be able to help you. I'm certain that it can be solved but I'm not sure whether it should be solved in the backend or the frontend. Be...
-
Hi Danilo. Let me try to help you. Can you provide me of your concrete example for me to understand what you are trying to achieve? Is it like a cross table covering a YTD period with no month dime...
-
Why not just load * like this: SELECT *FROM [C:\transactions\csv\Nettodisp.csv] (METADATA: Lagersted(type:string, ordinal:1)) The only dependency is hereby that "Lagersted" has to be the second col...
-
Thought so :-) Let me find out how it is done.
-
Thank you for the file. I had to change two things to make it work. 1. The "ordinal" must apparently be zero indexed, so when you have column 2, just write "ordinal:1" I was not aware of that. 2. S...
-
Hi Allan. Your data source and code looks correct, so strange. Are you willing to share your file or parts of it?
-
Hi Allan. It is actually possible. Consider this example, where I load five columns. The "Test" column has your exact problem in it. The zero is removed since it is loaded as INT64. But you can def...
-
Nice post Jesper. Just created a new In Memory Project, pasted in the script and changed the "filepath". Runs out-of-the-box and my 21 files are imported into one table. Thanks :-)