Allan Vittrup
Activity overview
Latest activity by Allan Vittrup-
Allan Vittrup commented, 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...
-
Allan Vittrup commented, 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...
-
Allan Vittrup created a post, Custom File location for Global Macros in InMemory ETL Studio
The idea is to be able to change “Macro File location” For now, it seems that the folder is hardcoded to this location: C:\Users\av\AppData\Roaming\TARGIT\TARGIT InMemory ETL Studio\Macro Where “av...
-
Allan Vittrup commented, 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...
-
Allan Vittrup commented, Thought so :-) Let me find out how it is done.
-
Allan Vittrup commented, 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...
-
Allan Vittrup commented, Hi Allan. Your data source and code looks correct, so strange. Are you willing to share your file or parts of it?
-
Allan Vittrup commented, 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...
-
Allan Vittrup commented, 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 :-)